DataAccess - BLToolkit.NET Documentation




• Introduction



Abstract accessors.

• Open and Configure	How to open and configure data accessors.
• Transactions



• AbstractAccessor	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