DataAccess

Modified on 2010/03/13 17:22 by IT — Categorized as: DadaAccess

Introduction

Abstract accessors.

Open and ConfigureHow to open and configure data accessors.
Transactions
Abstract AccessorAbstract accessor example.
ExecuteListDataAccessor + List.
ExecuteDictionaryDataAccessor + Dictionary.
ExecuteObjectDataAccessor + business objects.
ExecuteScalarDataAccessor + scalar values.

Abstract accessor attributes.

ActionNameActionSprocNameActualType
CommandBehaviorDataSetTableDestination
DirectionDiscoverParametersFormat
IndexObjectTypeParamDbType
ParamNameParamNullValueParamSize
ScalarFieldNameScalarSourceSprocName
SqlQueryCustom SqlQuery 1Custom SqlQuery 2

SqlQuery & SprocQuery

Open and ConfigureHow to open and configure SqlQuery & SprocQuery.

Basic CRUDL operations and SQL text generation.

SelectByKeySqlReads a record by Primary Key.
SelectAllSqlReads all records from specified table.
InsertSqlInserts a new record.
UpdateSqlUpdates a record.
DeleteSqlDeletes a record either by Primary Key or by provided object.

Basic CRUDL operations and stored procedures.

SelectByKeyReads a record by Primary Key.
SelectAllReads all records from specified table.
InsertInserts a new record.
UpdateUpdates a record.
DeleteDeletes a record either by Primary Key or by provided object.

SQL text generation control attributes.

TableName
PrimaryKey
NonUpdatable
XmlExtension