Navigation ¶

• Random Page
• Create a new Page
• All Pages
• Categories
• Navigation Paths
  

• Administration
• File Management
  

• Create Account
  

Search the wiki
»

DataAccess

• Introduction

Abstract accessors.

• Open and Configure	How to open and configure data accessors.
• Transactions
• Abstract Accessor	Abstract accessor example.
• ExecuteList	DataAccessor + List.
• ExecuteDictionary	DataAccessor + Dictionary.
• ExecuteObject	DataAccessor + business objects.
• ExecuteScalar	DataAccessor + scalar values.

Abstract accessor attributes.

• ActionName	• ActionSprocName	• ActualType
• CommandBehavior	• DataSetTable	• Destination
• Direction	• DiscoverParameters	• Format
• Index	• ObjectType	• ParamDbType
• ParamName	• ParamNullValue	• ParamSize
• ScalarFieldName	• ScalarSource	• SprocName
• SqlQuery	• Custom SqlQuery 1	• Custom SqlQuery 2

SqlQuery & SprocQuery

• Open and Configure

How to open and configure SqlQuery & SprocQuery.

Basic CRUDL operations and SQL text generation.

• SelectByKeySql	Reads a record by Primary Key.
• SelectAllSql	Reads all records from specified table.
• InsertSql	Inserts a new record.
• UpdateSql	Updates a record.
• DeleteSql	Deletes a record either by Primary Key or by provided object.

Basic CRUDL operations and stored procedures.

• SelectByKey	Reads a record by Primary Key.
• SelectAll	Reads all records from specified table.
• Insert	Inserts a new record.
• Update	Updates a record.
• Delete	Deletes a record either by Primary Key or by provided object.

SQL text generation control attributes.

• TableName

• PrimaryKey

• NonUpdatable

• XmlExtension