IDataAccessAdapter Interface

Gets or sets the active recovery strategy to use with supported actions on this DataAccessAdapter. If null (default), no recovery strategy is used and all exceptions are fatal.

Gets / sets the size of the batch command when performing multiple entity insert / update / delete statements. If set to a value of 0, every entity insert / update / delete statement will be executed using its own DbCommand. If set to a value of 2 or higher, insert / update / delete statements are packed together into a single DbCommand, the number of packed statements is equal or lower than the value of BatchSize. Packed statements are queries with multiple SQL statements packed together in a single DbCommand. It's not recommended to set this property to a very high value, as databases process packed SQL statements slower than single commands and as parameter names are unique across the complete SQL string, re-using execution plans is not always possible. Set BatchSize to a value of 30 or lower for most operations; it's primarily used to mitigate network latency: the higher the network latency the higher BatchSize can become, to the point where processing the packed SQL string by the database is slower than the combined network latency of all single SQL statements.

Gets / sets the timeout value to use with the command object(s) created by the adapter. Default is 30 seconds Set this prior to calling a method which executes database logic.

Gets / sets the connection string to use for the connection with the database.

Gets the function mappings for the DQE related to this object. These function mappings are static and therefore not changeable.

Gets a value indicating whether a System.Transactions transaction is going on. If not, false is returned.

Gets IsTransactionInProgress. True when there is a transaction in progress.

Gets / sets KeepConnectionOpen, a flag used to keep open connections after a database action has finished.

The flag (default true) to signal the adapter that entities participating in a transaction controlled by this adapter are tracked during the transaction and which values are rolled back after a rollback of the transaction itself. Only set this flag to false if the entities participating in a transaction are not kept in memory during or after the transaction's life time.

Gets or sets the parameterised prefetch path threshold. This threshold is used to determine when the prefetch path logic should switch to a subquery or when it should use a WHERE field IN (value1, value2, ... valueN) construct, based on the # of elements in the parent collection. If that # of elements exceeds this threshold, a subquery is constructed, otherwise field IN (value1, value2, ...) construct is used. The default value is 50. On average, this is faster than using a subquery which returns 50 elements. Use this to tune prefetch path fetch logic for your particular needs.

This threshold is also used to determine if paging is possible. A page size bigger than this threshold will disable the paging functionality when using paging + prefetch paths.

Gets / sets the isolation level a transaction should use. Setting this during a transaction in progress has no effect on the current running transaction.

Gets the name of the transaction. Setting this during a transaction in progress has no effect on the current running transaction.

Calls the specified action stored procedure in the database. If a transaction is in progress, it will participate in that transaction.

Async variant of CallActionStoredProcedure(String, DbParameter) Calls the specified action stored procedure in the database. If a transaction is in progress, it will participate in that transaction.

Calls the specified retrieval stored procedure in the database. Fills the specified DataSet. Will participate in the transaction if a transaction is in progress.

Calls the specified retrieval stored procedure in the database. Fills the specified datatable. Will participate in the transaction if a transaction is in progress.

Closes the active connection. If no connection is available or the connection is closed, nothing is done.

Commits the controlled ado.net transaction

Creates a new predicate expression which filters on the primary key fields and the set values for the given primary key fields. If no primary key fields are specified, null is returned.

Deletes all entities of the name passed in as entityName (e.g. "CustomerEntity") from the persistent storage if they match the filter supplied in filterBucket.

Deletes all entities of the name passed in as entityName (e.g. "CustomerEntity") from the persistent storage if they match the filter supplied in filterBucket.

Async variant of DeleteEntitiesDirectly(String, IRelationPredicateBucket). Deletes all entities of the name passed in as entityName (e.g. "CustomerEntity") from the persistent storage if they match the filter supplied in filterBucket.

Async variant of DeleteEntitiesDirectly(Type, IRelationPredicateBucket). Deletes all entities of the type passed in from the persistent storage if they match the filter supplied in filterBucket.

Async variant of DeleteEntitiesDirectly(String, IRelationPredicateBucket). Deletes all entities of the name passed in as entityName (e.g. "CustomerEntity") from the persistent storage if they match the filter supplied in filterBucket.

Async variant of DeleteEntitiesDirectly(Type, IRelationPredicateBucket). Deletes all entities of the type passed in from the persistent storage if they match the filter supplied in filterBucket.

Deletes the specified entity from the persistent storage. The entity is not usable after this call, the state is set to OutOfSync. Will use the current transaction if a transaction is in progress.

Deletes the specified entity from the persistent storage. The entity is not usable after this call, the state is set to OutOfSync. Will use the current transaction if a transaction is in progress.

Async variant of DeleteEntity(IEntity2). Deletes the specified entity from the persistent storage. The entity is not usable after this call, the state is set to OutOfSync. Will use the current transaction if a transaction is in progress. If the passed in entity has a concurrency predicate factory object, the returned predicate expression is used to restrict the delete process.

Async variant of DeleteEntity(IEntity2, IPredicateExpression). Deletes the specified entity from the persistent storage. The entity is not usable after this call, the state is set to OutOfSync. Will use the current transaction if a transaction is in progress.

Async variant of DeleteEntity(IEntity2). Deletes the specified entity from the persistent storage. The entity is not usable after this call, the state is set to OutOfSync. Will use the current transaction if a transaction is in progress. If the passed in entity has a concurrency predicate factory object, the returned predicate expression is used to restrict the delete process.

Async variant of DeleteEntity(IEntity2, IPredicateExpression). Deletes the specified entity from the persistent storage. The entity is not usable after this call, the state is set to OutOfSync. Will use the current transaction if a transaction is in progress.

Deletes all dirty objects inside the collection passed from the persistent storage. It will do this inside a transaction if a transaction is not yet available. Entities which are physically deleted from the persistent storage are marked with the state 'Deleted' but are not removed from the collection. If the passed in entity has a concurrency predicate factory object, the returned predicate expression is used to restrict the delete process.

Async variant of DeleteEntityCollection(IEntityCollection2). Deletes all dirty objects inside the collection passed from the persistent storage. It will do this inside a transaction if a transaction is not yet available. Entities which are physically deleted from the persistent storage are marked with the state 'Deleted' but are not removed from the collection.

Async variant of DeleteEntityCollection(IEntityCollection2). Deletes all dirty objects inside the collection passed from the persistent storage. It will do this inside a transaction if a transaction is not yet available. Entities which are physically deleted from the persistent storage are marked with the state 'Deleted' but are not removed from the collection.

Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.

Executes the passed in action query and, if not null, runs it inside the passed in transaction.

Async variant of ExecuteActionQuery(IActionQuery). Executes the passed in action query and, if not null, runs it inside the passed in transaction.

Executes the passed in retrieval query and returns the results as a datatable using the passed in data-adapter. It sets the connection object of the command object of query object passed in to the connection object of this class.

Executes the passed in retrieval query and returns the results in thedatatable specified using the passed in data-adapter. It sets the connection object of the command object of query object passed in to the connection object of this class.

Async variant of ExecuteMultiRowDataTableRetrievalQuery(IRetrievalQuery, DbDataAdapter, DataTable, IFieldPersistenceInfo). Executes the passed in retrieval query and returns the results in thedatatable specified using the passed in data-adapter. It sets the connection object of the command object of query object passed in to the connection object of this class.

Executes the passed in retrieval query and, if not null, runs it inside the passed in transaction. Used to read 1 or more rows. It sets the connection object of the command object of query object passed in to the connection object of this class.

Async variant of ExecuteMultiRowRetrievalQuery(IRetrievalQuery, IEntityFactory2, IEntityCollection2, IFieldPersistenceInfo, Boolean, IEntityFields2). Executes the passed in retrieval query and, if not null, runs it inside the passed in transaction. Used to read 1 or more rows. It sets the connection object of the command object of query object passed in to the connection object of this class.

Executes the passed in query as a scalar query and returns the value returned from this scalar execution.

Executes the passed in retrieval query and, if not null, runs it inside the passed in transaction. Used to read 1 row. It sets the connection object of the command object of query object passed in to the connection object of this class.

Executes the specified plain SQL query using this adapter. Every parameter value is converted into one or more parameters which have to be pre-defined in the sqlQuery

Async variant of ExecuteSQL(String, Object) Executes the specified plain SQL query using this adapter. Every parameter value is converted into one or more parameters which have to be pre-defined in the sqlQuery

Async variant of ExecuteSQL(String, Object) Executes the specified plain SQL query using this adapter. Every parameter value is converted into one or more parameters which have to be pre-defined in the sqlQuery

Creates a new Retrieval query from the elements passed in and executes that retrievalquery to return an open, ready to use IDataReader. The datareader's command behavior is set to the readerBehavior passed in. If a transaction is in progress, the command is wired to the transaction.

Executes the passed in retrievalquery and returns an open, ready to use IDataReader. The datareader's command behavior is set to the readerBehavior passed in. If a transaction is in progress, the command is wired to the transaction.

Creates a new Retrieval query from the elements passed in and executes that retrievalquery to return an open, ready to use IDataReader. The datareader's command behavior is set to the readerBehavior passed in. If a transaction is in progress, the command is wired to the transaction.

Creates a new Retrieval query from the elements passed in and executes that retrievalquery to return an open, ready to use IDataReader. The datareader's command behavior is set to the readerBehavior passed in. If a transaction is in progress, the command is wired to the transaction.

Creates a new Retrieval query from the elements passed in and executes that retrievalquery to return an open, ready to use IDataReader. The datareader's command behavior is set to the readerBehavior passed in. If a transaction is in progress, the command is wired to the transaction.

Creates a new Retrieval query from the elements passed in and executes that retrievalquery to return an open, ready to use IDataReader. The datareader's command behavior is set to the readerBehavior passed in. If a transaction is in progress, the command is wired to the transaction.

Async variant of FetchDataReader(CommandBehavior, QueryParameters). Creates a new Retrieval query from the elements passed in and executes that retrievalquery to return an open, ready to use IDataReader. The datareader's command behavior is set to the readerBehavior passed in. If a transaction is in progress, the command is wired to the transaction.

Async variant of FetchDataReader(IRetrievalQuery, CommandBehavior). Executes the passed in retrievalquery and returns an open, ready to use IDataReader. The datareader's command behavior is set to the readerBehavior passed in. If a transaction is in progress, the command is wired to the transaction.

Fetches an entity from the persistent storage into the passed in Entity2 object using a primary key filter. The primary key fields of the entity passed in have to have the primary key values. (Example: CustomerID has to have a value, when you want to fetch a CustomerEntity from the persistent storage into the passed in object)

Fetches an entity from the persistent storage into the passed in Entity2 object using a primary key filter. The primary key fields of the entity passed in have to have the primary key values. (Example: CustomerID has to have a value, when you want to fetch a CustomerEntity from the persistent storage into the passed in object)

Fetches an entity from the persistent storage into the passed in Entity2 object using a primary key filter. The primary key fields of the entity passed in have to have the primary key values. (Example: CustomerID has to have a value, when you want to fetch a CustomerEntity from the persistent storage into the passed in object)

Fetches an entity from the persistent storage into the passed in Entity2 object using a primary key filter. The primary key fields of the entity passed in have to have the primary key values. (Example: CustomerID has to have a value, when you want to fetch a CustomerEntity from the persistent storage into the passed in object)

Fetches an entity from the persistent storage into the passed in Entity2 object using a primary key filter. The primary key fields of the entity passed in have to have the primary key values. (Example: CustomerID has to have a value, when you want to fetch a CustomerEntity from the persistent storage into the passed in object). All fields specified in excludedFields are excluded from the fetch so the entity won't get any value set for those fields. excludedFields can be null or empty, in which case all fields are fetched (default).

Fetches one or more entities which match the filter information in the parameters into the EntityCollection passed. The entity collection object has to contain an entity factory object which will be the factory for the entity instances to be fetched. It will apply paging and it will from there use a prefetch path fetch using the read page. It's important that pageSize is smaller than the set ParameterisedPrefetchPathThreshold. If pagesize is larger than the limits set for the ParameterisedPrefetchPathThreshold value, the query is likely to be slower than expected, though will work. If pageNumber / pageSize are set to values which disable paging, a normal prefetch path fetch will be performed.

Fetches one or more entities which match the filter information in the filterBucket into the EntityCollection passed. The entity collection object has to contain an entity factory object which will be the factory for the entity instances to be fetched. This overload returns all found entities and doesn't apply sorting

Fetches one or more entities which match the filter information in the filterBucket into the EntityCollection passed. The entity collection object has to contain an entity factory object which will be the factory for the entity instances to be fetched. This overload returns all found entities and doesn't apply sorting

Fetches one or more entities which match the filter information in the filterBucket into the EntityCollection passed. The entity collection object has to contain an entity factory object which will be the factory for the entity instances to be fetched. This overload returns all found entities and doesn't apply sorting

Fetches one or more entities which match the filter information in the filterBucket into the EntityCollection passed. The entity collection object has to contain an entity factory object which will be the factory for the entity instances to be fetched. This overload doesn't apply sorting

Fetches one or more entities which match the filter information in the filterBucket into the EntityCollection passed. The entity collection object has to contain an entity factory object which will be the factory for the entity instances to be fetched.

Fetches one or more entities which match the filter information in the filterBucket into the EntityCollection passed. The entity collection object has to contain an entity factory object which will be the factory for the entity instances to be fetched.

Fetches one or more entities which match the filter information in the filterBucket into the EntityCollection passed. The entity collection object has to contain an entity factory object which will be the factory for the entity instances to be fetched.

Fetches one or more entities which match the filter information in the filterBucket into the EntityCollection passed. The entity collection object has to contain an entity factory object which will be the factory for the entity instances to be fetched.

Fetches one or more entities which match the filter information in the filterBucket into the EntityCollection passed. The entity collection object has to contain an entity factory object which will be the factory for the entity instances to be fetched. It will apply paging and it will from there use a prefetch path fetch using the read page. It's important that pageSize is smaller than the set ParameterisedPrefetchPathThreshold. It will work, though if pagesize is larger than the limits set for the ParameterisedPrefetchPathThreshold value, the query is likely to be slower than expected.

Fetches one or more entities which match the filter information in the filterBucket into the EntityCollection passed. The entity collection object has to contain an entity factory object which will be the factory for the entity instances to be fetched. It will apply paging and it will from there use a prefetch path fetch using the read page. It's important that pageSize is smaller than the set ParameterisedPrefetchPathThreshold. If pagesize is larger than the limits set for the ParameterisedPrefetchPathThreshold value, the query is likely to be slower than expected, though will work. If pageNumber / pageSize are set to values which disable paging, a normal prefetch path fetch will be performed.

Async variant of FetchEntityCollection(QueryParameters). Fetches one or more entities which match the filter information in the parameters into the EntityCollection passed. The entity collection object has to contain an entity factory object which will be the factory for the entity instances to be fetched. It will apply paging and it will from there use a prefetch path fetch using the read page. It's important that pageSize is smaller than the set ParameterisedPrefetchPathThreshold. If pagesize is larger than the limits set for the ParameterisedPrefetchPathThreshold value, the query is likely to be slower than expected, though will work. If pageNumber / pageSize are set to values which disable paging, a normal prefetch path fetch will be performed.

Fetches an entity from the persistent storage into the object specified using the filter specified. Use the entity's uniqueconstraint filter construction methods to construct the required uniqueConstraintFilter for the unique constraint you want to use.

Fetches an entity from the persistent storage into the object specified using the filter specified. Use the entity's uniqueconstraint filter construction methods to construct the required uniqueConstraintFilter for the unique constraint you want to use.

Fetches an entity from the persistent storage into the object specified using the filter specified. Use the entity's uniqueconstraint filter construction methods to construct the required uniqueConstraintFilter for the unique constraint you want to use.

Fetches an entity from the persistent storage into the object specified using the filter specified. Use the entity's uniqueconstraint filter construction methods to construct the required uniqueConstraintFilter for the unique constraint you want to use.

Fetches an entity from the persistent storage into the object specified using the filter specified. Use the entity's uniqueconstraint filter construction methods to construct the required uniqueConstraintFilter for the unique constraint you want to use.

Fetches the excluded field batch defined by the parameters specified. The returned reader is used by the batch fetcher to merge the resultset it represents into the entities hold by the caller.

Async variant of FetchExcludedFieldBatch(IEntityFieldsCore, IRelationPredicateBucket, Int32). Fetches the excluded field batch defined by the parameters specified. The returned reader is used by the batch fetcher to merge the resultset it represents into the entities hold by the caller.

Loads the data for the excluded fields specified in the list of excluded fields into the entity passed in.

Loads the data for the excluded fields specified in the list of excluded fields into all the entities in the entities collection passed in.

Async variant of FetchExcludedFields(IEntity2, ExcludeIncludeFieldsList). Loads the data for the excluded fields specified in the list of excluded fields into the entity passed in.

Async variant of FetchExcludedFields(IEntityCollection2, ExcludeIncludeFieldsList). Loads the data for the excluded fields specified in the list of excluded fields into all the entities in the entities collection passed in.

Async variant of FetchExcludedFields(IEntity2, ExcludeIncludeFieldsList). Loads the data for the excluded fields specified in the list of excluded fields into the entity passed in.

Async variant of FetchExcludedFields(IEntityCollection2, ExcludeIncludeFieldsList). Loads the data for the excluded fields specified in the list of excluded fields into all the entities in the entities collection passed in.

Fetches a new entity using the filter/relation combination filter passed in via filterBucket and the new entity is created using the passed in entity factory. Use this method when fetching a related entity using a current entity (for example, fetch the related Customer entity of an existing Order entity)

Fetches a new entity using the filter/relation combination filter passed in via filterBucket and the new entity is created using the passed in entity factory. Use this method when fetching a related entity using a current entity (for example, fetch the related Customer entity of an existing Order entity)

Fetches a new entity using the filter/relation combination filter passed in via filterBucket and the new entity is created using the passed in entity factory. Use this method when fetching a related entity using a current entity (for example, fetch the related Customer entity of an existing Order entity)

Fetches a new entity using the filter/relation combination filter passed in via filterBucket and the new entity is created using the passed in entity factory. Use this method when fetching a related entity using a current entity (for example, fetch the related Customer entity of an existing Order entity)

Fetches a new entity using the filter/relation combination filter passed in via filterBucket and the new entity is created using the passed in entity factory. Use this method when fetching a related entity using a current entity (for example, fetch the related Customer entity of an existing Order entity)

Fetches a new entity using the filter/relation combination filter passed in via filterBucket and the new entity is created using the specified generic type. Use this method when fetching a related entity using a current entity (for example, fetch the related Customer entity of an existing Order entity)

Fetches a new entity using the filter/relation combination filter passed in via filterBucket and the new entity is created using the specified generic type. Use this method when fetching a related entity using a current entity (for example, fetch the related Customer entity of an existing Order entity)

Fetches a new entity using the filter/relation combination filter passed in via filterBucket and the new entity is created using the specified generic type. Use this method when fetching a related entity using a current entity (for example, fetch the related Customer entity of an existing Order entity)

Fetches a new entity using the filter/relation combination filter passed in via filterBucket and the new entity is created using the specified generic type. Use this method when fetching a related entity using a current entity (for example, fetch the related Customer entity of an existing Order entity)

Fetches a new entity using the filter/relation combination filter passed in via filterBucket and the new entity is created using the specified generic type. Use this method when fetching a related entity using a current entity (for example, fetch the related Customer entity of an existing Order entity)

Executes the passed in retrievalquery and projects the resultset using the value projectors and the projector specified. IF a transaction is in progress, the command is wired to the transaction and executed inside the transaction. The projection results will be stored in the projector.

Creates a new Retrieval query from the elements passed in, executes that retrievalquery and projects the resultset of that query using the value projectors and the projector specified. If a transaction is in progress, the command is wired to the transaction and executed inside the transaction. The projection results will be stored in the projector.

Projects the current resultset of the passed in datareader using the value projectors and the projector specified. The reader will be left open

Projects the current resultset of the passed in datareader using the value projectors and the projector specified. The reader will be left open

Creates a new Retrieval query from the elements passed in, executes that retrievalquery and projects the resultset of that query using the value projectors and the projector specified. If a transaction is in progress, the command is wired to the transaction and executed inside the transaction. The projection results will be stored in the projector.

Creates a new Retrieval query from the elements passed in, executes that retrievalquery and projects the resultset of that query using the value projectors and the projector specified. If a transaction is in progress, the command is wired to the transaction and executed inside the transaction. The projection results will be stored in the projector.

Creates a new Retrieval query from the elements passed in, executes that retrievalquery and projects the resultset of that query using the value projectors and the projector specified. If a transaction is in progress, the command is wired to the transaction and executed inside the transaction. The projection results will be stored in the projector.

Creates a new Retrieval query from the elements passed in, executes that retrievalquery and projects the resultset of that query using the value projectors and the projector specified. If a transaction is in progress, the command is wired to the transaction and executed inside the transaction. The projection results will be stored in the projector.

Projects the current resultset of the passed in datareader using the value projectors and the projector specified. The reader will be left open

Executes the passed in retrievalquery and projects the resultset onto instances of T (each row is materialized into an instance of T). If a transaction is in progress, the command is wired to the transaction and executed inside the transaction.

Projects the current resultset of the passed in datareader using the value projectors and the projector specified. The reader will be left open

Async variant of FetchProjection(ListIDataValueProjector, IGeneralDataProjector, IRetrievalQuery) Executes the passed in retrievalquery and projects the resultset using the value projectors and the projector specified. IF a transaction is in progress, the command is wired to the transaction and executed inside the transaction. The projection results will be stored in the projector.

Async variant of FetchProjection(ListIDataValueProjector, IGeneralDataProjector, QueryParameters). Creates a new Retrieval query from the elements passed in, executes that retrievalquery and projects the resultset of that query using the value projectors and the projector specified. If a transaction is in progress, the command is wired to the transaction and executed inside the transaction. The projection results will be stored in the projector.

Async variant of FetchProjectionT(IRetrievalQuery) Executes the passed in retrievalquery and projects the resultset onto instances of T (each row is materialized into an instance of T). If a transaction is in progress, the command is wired to the transaction and executed inside the transaction.

Async variant of FetchProjectionT(IRetrievalQuery) Executes the passed in retrievalquery and projects the resultset onto instances of T (each row is materialized into an instance of T). If a transaction is in progress, the command is wired to the transaction and executed inside the transaction.

Executes the specified plain SQL query using this adapter and projects each row in the resultset to an instance of T. Every parameter value is converted into one or more parameters which have to be pre-defined in the sqlQuery. Uses default fetch aspects.

Executes the specified plain SQL query using this adapter and projects each row in the resultset to an instance of T. Every parameter value is converted into one or more parameters which have to be pre-defined in the sqlQuery.

Async variant of FetchQueryT(String, Object) Executes the specified plain SQL query using this adapter and projects each row in the resultset to an instance of T. Every parameter value is converted into one or more parameters which have to be pre-defined in the sqlQuery. Uses default fetch aspects.

Async variant of FetchQueryT(String, Object) Executes the specified plain SQL query using this adapter and projects each row in the resultset to an instance of T. Every parameter value is converted into one or more parameters which have to be pre-defined in the sqlQuery. Uses default fetch aspects.

Async variant of FetchQueryT(PlainSQLFetchAspects, String, Object) Executes the specified plain SQL query using this adapter and projects each row in the resultset to an instance of T. Every parameter value is converted into one or more parameters which have to be pre-defined in the sqlQuery.

Async variant of FetchQueryT(PlainSQLFetchAspects, String, Object) Executes the specified plain SQL query using this adapter and projects each row in the resultset to an instance of T. Every parameter value is converted into one or more parameters which have to be pre-defined in the sqlQuery.

Executes the specified plain SQL query using this adapter and returns the first scalar value returned as an instance of T. Every parameter value is converted into one or more parameters which have to be pre-defined in the sqlQuery. Uses default fetch aspects.

Executes the specified plain SQL query using this adapter and returns the first scalar value returned as an instance of T. Every parameter value is converted into one or more parameters which have to be pre-defined in the sqlQuery.

Async variant of FetchScalarQueryT(String, Object). Executes the specified plain SQL query using this adapter and returns the first scalar value returned as an instance of T. Every parameter value is converted into one or more parameters which have to be pre-defined in the sqlQuery. Uses default fetch aspects.

Async variant of FetchScalarQueryT(String, Object). Executes the specified plain SQL query using this adapter and returns the first scalar value returned as an instance of T. Every parameter value is converted into one or more parameters which have to be pre-defined in the sqlQuery. Uses default fetch aspects.

Async variant of FetchScalarQueryT(PlainSQLFetchAspects, String, Object). Executes the specified plain SQL query using this adapter and returns the first scalar value returned as an instance of T. Every parameter value is converted into one or more parameters which have to be pre-defined in the sqlQuery.

Async variant of FetchScalarQueryT(PlainSQLFetchAspects, String, Object). Executes the specified plain SQL query using this adapter and returns the first scalar value returned as an instance of T. Every parameter value is converted into one or more parameters which have to be pre-defined in the sqlQuery.

Fetches the fields passed in fieldCollectionToFetch from the persistent storage using the relations and filter information stored in the passed in typed list. For TypedView filling, use the method FetchTypedView()

Fetches the fields passed in fieldCollectionToFetch from the persistent storage using the relations and filter information stored in filterBucket into the DataTable object passed in. Use this routine to fill a typed list object. For TypedView filling, use the method FetchTypedView()

Fetches the fields passed in fieldCollectionToFetch from the persistent storage using the relations and filter information stored in the passed in typed list. For TypedView filling, use the method FetchTypedView()

Fetches the fields passed in fieldCollectionToFetch from the persistent storage using the relations and filter information stored in filterBucket into the DataTable object passed in. Use this routine to fill a typed list object. Doesn't apply any sorting, doesn't limit the resultset on the amount of rows to return, does allow duplicates. For TypedView filling, use the method FetchTypedView()

Fetches the fields passed in fieldCollectionToFetch from the persistent storage using the relations and filter information stored in filterBucket into the DataTable object passed in. Use this routine to fill a typed list object. Doesn't apply any sorting, doesn't limit the resultset on the amount of rows to return. For TypedView filling, use the method FetchTypedView()

Fetches the fields passed in fieldCollectionToFetch from the persistent storage using the relations and filter information stored in filterBucket into the DataTable object passed in. Use this routine to fill a typed list object. Doesn't apply any sorting. For TypedView filling, use the method FetchTypedView()

Fetches the fields passed in fieldCollectionToFetch from the persistent storage using the relations and filter information stored in the passed in typed list. For TypedView filling, use the method FetchTypedView()

Fetches the fields passed in fieldCollectionToFetch from the persistent storage using the relations and filter information stored in filterBucket into the DataTable object passed in. Use this routine to fill a typed list object. For TypedView filling, use the method FetchTypedView()

Fetches the fields passed in fieldCollectionToFetch from the persistent storage using the relations and filter information stored in filterBucket into the DataTable object passed in. Use this routine to fill a typed list object. For TypedView filling, use the method FetchTypedView()

Fetches the fields passed in fieldCollectionToFetch from the persistent storage using the relations and filter information stored in the passed in typed list. For TypedView filling, use the method FetchTypedView()

Fetches the fields passed in fieldCollectionToFetch from the persistent storage using the relations and filter information stored in filterBucket into the DataTable object passed in. Use this routine to fill a typed list object. For TypedView filling, use the method FetchTypedView()

Async variant of FetchTypedList(DataTable, QueryParameters). Fetches the fields passed in fieldCollectionToFetch from the persistent storage using the relations and filter information stored in filterBucket into the DataTable object passed in. Use this routine to fill a typed list object. For TypedView filling, use the method FetchTypedView()

Fetches the Typed View passed in from the persistent storage Doesn't apply any sorting, doesn't limit the amount of rows returned by the query, doesn't apply any filtering, allows duplicate rows. Use this routine to fill a TypedView object.

Fetches the Typed View fields passed in fieldCollectionToFetch from the persistent storage using the query information stored in parameters into the DataTable object passed in. Use this routine to fill a TypedView object.

Fetches the Typed View fields passed in fieldCollectionToFetch from the persistent storage into the DataTable object passed in. Doesn't apply any sorting, doesn't limit the amount of rows returned by the query, doesn't apply any filtering, allows duplicate rows. Use this routine to fill a TypedView object.

Fetches the typed view, using the query specified.

Fetches the Typed View passed in from the persistent storage Doesn't apply any sorting, doesn't limit the amount of rows returned by the query, doesn't apply any filtering. Use this routine to fill a TypedView object.

Fetches the Typed View fields passed in fieldCollectionToFetch from the persistent storage into the DataTable object passed in. Doesn't apply any sorting, doesn't limit the amount of rows returned by the query, doesn't apply any filtering. Use this routine to fill a TypedView object.

Fetches the Typed View passed in from the persistent storage Doesn't apply any sorting, doesn't limit the amount of rows returned by the query. Use this routine to fill a TypedView object.

Fetches the Typed View fields passed in fieldCollectionToFetch from the persistent storage using the filter information stored in filterBucket into the DataTable object passed in. Doesn't apply any sorting, doesn't limit the amount of rows returned by the query. Use this routine to fill a TypedView object.

Fetches the Typed View passed in from the persistent storage Doesn't apply any sorting. Use this routine to fill a TypedView object.

Fetches the Typed View fields passed in fieldCollectionToFetch from the persistent storage using the filter information stored in filterBucket into the DataTable object passed in. Doesn't apply any sorting Use this routine to fill a TypedView object.

Fetches the Typed View passed in from the persistent storage

Fetches the Typed View fields passed in fieldCollectionToFetch from the persistent storage using the filter information stored in filterBucket into the DataTable object passed in. Use this routine to fill a TypedView object.

Fetches the Typed View passed in from the persistent storage

Fetches the Typed View fields passed in fieldCollectionToFetch from the persistent storage using the filter information stored in filterBucket into the DataTable object passed in. Use this routine to fill a TypedView object.

Fetches the Typed View fields passed in fieldCollectionToFetch from the persistent storage using the filter information stored in filterBucket into the DataTable object passed in. Use this routine to fill a TypedView object.

Gets the estimated number of objects returned by a query for objects to store in the entity collection passed in, using the filter and groupby clause specified. The number is estimated as duplicate objects can be present in the plain query results, but will be filtered out when the query result is transformed into objects.

Gets the number of rows returned by a query for the fields specified, using the filter and groupby clause specified.

Gets the estimated number of objects returned by a query for objects to store in the entity collection passed in, using the filter and groupby clause specified. The number is estimated as duplicate objects can be present in the plain query results, but will be filtered out when the query result is transformed into objects.

Gets the number of rows returned by a query for the fields specified, using the filter and groupby clause specified.

Gets the number of rows returned by a query for the fields specified, using the filter and groupby clause specified.

Gets the DB provider factory instance.

Gets the db specific creator instance for the database this object targets.

Gets a scalar value, calculated with the aggregate and expression specified. the field specified is the field the expression and aggregate are applied on.

Gets a scalar value, calculated with the aggregate and expression specified. the field specified is the field the expression and aggregate are applied on.

Executes the expression defined with the field in the fields collection specified, using the various elements defined. The expression is executed as a scalar query and a single value is returned.

Gets a scalar value, calculated with the aggregate and expression specified. the field specified is the field the expression and aggregate are applied on.

Executes the expression defined with the field in the fields collection specified, using the various elements defined. The expression is executed as a scalar query and a single value is returned.

Gets a scalar value, calculated with the aggregate and expression specified. the field specified is the field the expression and aggregate are applied on.

Gets a scalar value, calculated with the aggregate and expression specified. the field specified is the field the expression and aggregate are applied on.

Opens the active connection object. If the connection is already open, nothing is done. If no connection object is present, a new one is created

Async variant of OpenConnection. Opens the active connection object. If the connection is already open, nothing is done. If no connection object is present, a new one is created

Async variant of OpenConnection. Opens the active connection object. If the connection is already open, nothing is done. If no connection object is present, a new one is created

Creates the correct stored procedure name, i.e. with catalog / schema name replaced properly.

Rolls back the controlled ado.net transaction

Rolls back the transaction in action to the savepoint with the name savepointName. No internal objects are being reset when this method is called, so call this Rollback overload only to roll back to a savepoint. To roll back a complete transaction, call Rollback() without specifying a savepoint name. Create a savepoint by calling SaveTransaction(savePointName)

Saves the passed in entity to the persistent storage. Will not refetch the entity after this save. The entity will stay out-of-sync. If the entity is new, it will be inserted, if the entity is existent, the changed entity fields will be changed in the database. Will do a recursive save.

Saves the passed in entity to the persistent storage. If the entity is new, it will be inserted, if the entity is existent, the changed entity fields will be changed in the database. Will do a recursive save. Will pass the concurrency predicate returned by GetConcurrencyPredicate(ConcurrencyPredicateType.Save) as update restriction.

Saves the passed in entity to the persistent storage. If the entity is new, it will be inserted, if the entity is existent, the changed entity fields will be changed in the database. Will do a recursive save. Will pass the concurrency predicate returned by GetConcurrencyPredicate(ConcurrencyPredicateType.Save) as update restriction.

Saves the passed in entity to the persistent storage. If the entity is new, it will be inserted, if the entity is existent, the changed entity fields will be changed in the database. Will pass the concurrency predicate returned by GetConcurrencyPredicate(ConcurrencyPredicateType.Save) as update restriction.

Saves the passed in entity to the persistent storage. If the entity is new, it will be inserted, if the entity is existent, the changed entity fields will be changed in the database.

Async variant of SaveEntity(IEntity2). Saves the passed in entity to the persistent storage. Will not refetch the entity after this save. The entity will stay out-of-sync. If the entity is new, it will be inserted, if the entity is existent, the changed entity fields will be changed in the database. Will do a recursive save. Will pass the concurrency predicate returned by GetConcurrencyPredicate(ConcurrencyPredicateType.Save) as update restriction.

Async variant of SaveEntity(IEntity2, Boolean). Saves the passed in entity to the persistent storage. If the entity is new, it will be inserted, if the entity is existent, the changed entity fields will be changed in the database. Will do a recursive save. Will pass the concurrency predicate returned by GetConcurrencyPredicate(ConcurrencyPredicateType.Save) as update restriction.

Async variant of SaveEntity(IEntity2). Saves the passed in entity to the persistent storage. Will not refetch the entity after this save. The entity will stay out-of-sync. If the entity is new, it will be inserted, if the entity is existent, the changed entity fields will be changed in the database. Will do a recursive save. Will pass the concurrency predicate returned by GetConcurrencyPredicate(ConcurrencyPredicateType.Save) as update restriction.

Async variant of SaveEntity(IEntity2, Boolean, Boolean). Saves the passed in entity to the persistent storage. If the entity is new, it will be inserted, if the entity is existent, the changed entity fields will be changed in the database. Will pass the concurrency predicate returned by GetConcurrencyPredicate(ConcurrencyPredicateType.Save) as update restriction.

Async variant of SaveEntity(IEntity2, Boolean). Saves the passed in entity to the persistent storage. If the entity is new, it will be inserted, if the entity is existent, the changed entity fields will be changed in the database. Will do a recursive save. Will pass the concurrency predicate returned by GetConcurrencyPredicate(ConcurrencyPredicateType.Save) as update restriction.

Async variant of SaveEntity(IEntity2, Boolean, Boolean). Saves the passed in entity to the persistent storage. If the entity is new, it will be inserted, if the entity is existent, the changed entity fields will be changed in the database. Will pass the concurrency predicate returned by GetConcurrencyPredicate(ConcurrencyPredicateType.Save) as update restriction.

Async variant of SaveEntity(IEntity2, Boolean, IPredicateExpression, Boolean). Saves the passed in entity to the persistent storage. If the entity is new, it will be inserted, if the entity is existent, the changed entity fields will be changed in the database.

Saves all dirty objects inside the collection passed to the persistent storage. It will do this inside a transaction if a transaction is not yet available. Will not refetch saved entities and will not recursively save the entities.

Saves all dirty objects inside the collection passed to the persistent storage. It will do this inside a transaction if a transaction is not yet available.

Async variant of SaveEntityCollection(IEntityCollection2). Saves all dirty objects inside the collection passed to the persistent storage. It will do this inside a transaction if a transaction is not yet available. Will not refetch saved entities and will not recursively save the entities.

Async variant of SaveEntityCollection(IEntityCollection2). Saves all dirty objects inside the collection passed to the persistent storage. It will do this inside a transaction if a transaction is not yet available. Will not refetch saved entities and will not recursively save the entities.

Async variant of SaveEntityCollection(IEntityCollection2, Boolean, Boolean). Saves all dirty objects inside the collection passed to the persistent storage. It will do this inside a transaction if a transaction is not yet available.

Async variant of SaveEntityCollection(IEntityCollection2, Boolean, Boolean). Saves all dirty objects inside the collection passed to the persistent storage. It will do this inside a transaction if a transaction is not yet available.

Creates a savepoint with the name savePointName in the current transaction. You can roll back to this savepoint using Rollback(String).

Starts a new transaction. All database activity after this call will be ran in this transaction and all objects will participate in this transaction until its committed or rolled back. If there is a transaction in progress, an exception is thrown. Will create and open a new connection if a transaction is not open and/or available.

Async variant of StartTransaction(IsolationLevel, String). Starts a new transaction. All database activity after this call will be ran in this transaction and all objects will participate in this transaction until its committed or rolled back. If there is a transaction in progress, an exception is thrown. Will create and open a new connection if a transaction is not open and/or available.

Async variant of StartTransaction(IsolationLevel, String). Starts a new transaction. All database activity after this call will be ran in this transaction and all objects will participate in this transaction until its committed or rolled back. If there is a transaction in progress, an exception is thrown. Will create and open a new connection if a transaction is not open and/or available.

Updates all entities of the same type of the entity entityWithNewValues directly in the persistent storage if they match the filter supplied in filterBucket. Only the fields changed in entityWithNewValues are updated for these fields.

Async variant of UpdateEntitiesDirectly(IEntity2, IRelationPredicateBucket). Updates all entities of the same type or subtype of the entity entityWithNewValues directly in the persistent storage if they match the filter supplied in filterBucket. Only the fields changed in entityWithNewValues are updated for these fields. Entities of a subtype of the type of entityWithNewValues which are affected by the filterBucket's filter will thus also be updated.

Async variant of UpdateEntitiesDirectly(IEntity2, IRelationPredicateBucket). Updates all entities of the same type or subtype of the entity entityWithNewValues directly in the persistent storage if they match the filter supplied in filterBucket. Only the fields changed in entityWithNewValues are updated for these fields. Entities of a subtype of the type of entityWithNewValues which are affected by the filterBucket's filter will thus also be updated.

Raised when Commit was successful.

Raised when Rollback was successful.

Fetches the query as an open data reader.

Async variant of FetchAsDataReader(IDataAccessAdapter, DynamicQuery, CommandBehavior). Fetches the query as an open data reader.

Fetches the specified query into a new DataTable specified and returns that datatable.

Fetches the specified query into the DataTable specified and returns that datatable.

Async variant of FetchAsDataTable(IDataAccessAdapter, DynamicQuery). Fetches the specified query into a new DataTable specified and returns that datatable.

Async variant of FetchAsDataTable(IDataAccessAdapter, DynamicQuery, DataTable). Fetches the specified query into the DataTable specified and returns that datatable.

Async variant of FetchAsDataTable(IDataAccessAdapter, DynamicQuery). Fetches the specified query into a new DataTable specified and returns that datatable.

Async variant of FetchAsDataTable(IDataAccessAdapter, DynamicQuery, DataTable). Fetches the specified query into the DataTable specified and returns that datatable.

Fetches the query as a projection, using the projector specified.

Async variant of FetchAsProjection(IDataAccessAdapter, DynamicQuery, IGeneralDataProjector). Fetches the query as a projection, using the projector specified.

Async variant of FetchAsProjection(IDataAccessAdapter, DynamicQuery, IGeneralDataProjector). Fetches the query as a projection, using the projector specified.

Fetches the first object of the set returned by the query and returns that object, if any, otherwise null.

Fetches the first entity of the set returned by the query and returns that entity, if any, otherwise null.

Async variant of FetchFirstT(IDataAccessAdapter, DynamicQueryT). Fetches the first object of the set returned by the query and returns that object, if any, otherwise null.

Async variant of FetchFirstTEntity(IDataAccessAdapter, EntityQueryTEntity). Fetches the first entity of the set returned by the query and returns that entity, if any, otherwise null.

Async variant of FetchFirstT(IDataAccessAdapter, DynamicQueryT). Fetches the first object of the set returned by the query and returns that object, if any, otherwise null.

Async variant of FetchFirstTEntity(IDataAccessAdapter, EntityQueryTEntity). Fetches the first entity of the set returned by the query and returns that entity, if any, otherwise null.

Fetches the query specified and returns the results in plain object arrays, one object array per returned row of the query specified.

Fetches the query specified and returns the results in a list of TElement objects, which are created using the projectorFunc of the query specified.

Fetches the query specified on the adapter specified. Uses the TEntity type to produce an EntityCollection(Of TEntity) for the results to return

Fetches the query specified on the adapter specified into the collectionToFill specified.

Async variant of FetchQuery(IDataAccessAdapter, DynamicQuery). Fetches the query specified and returns the results in plain object arrays, one object array per returned row of the query specified.

Async variant of FetchQuery(IDataAccessAdapter, DynamicQuery). Fetches the query specified and returns the results in plain object arrays, one object array per returned row of the query specified.

Async variant of FetchQueryTElement(IDataAccessAdapter, DynamicQueryTElement). Fetches the query specified and returns the results in a list of TElement objects, which are created using the projectorFunc of the query specified.

Async variant of FetchQueryTEntity(IDataAccessAdapter, EntityQueryTEntity). Fetches the query specified on the adapter specified. Uses the TEntity type to produce an EntityCollection(Of TEntity) for the results to return

Async variant of FetchQueryTElement(IDataAccessAdapter, DynamicQueryTElement). Fetches the query specified and returns the results in a list of TElement objects, which are created using the projectorFunc of the query specified.

Async variant of FetchQueryTEntity(IDataAccessAdapter, EntityQueryTEntity). Fetches the query specified on the adapter specified. Uses the TEntity type to produce an EntityCollection(Of TEntity) for the results to return

Async variant of FetchQueryTEntity, TCollection(IDataAccessAdapter, EntityQueryTEntity, TCollection). Fetches the query specified on the adapter specified into the collectionToFill specified.

Async variant of FetchQueryTEntity, TCollection(IDataAccessAdapter, EntityQueryTEntity, TCollection). Fetches the query specified on the adapter specified into the collectionToFill specified.

Fetches the query with the projection specified from the source query specified. Typically used to fetch a typed view from a stored procedure source.

Async variant of FetchQueryFromSourceTElement(IDataAccessAdapter, DynamicQueryTElement, IRetrievalQuery) Fetches the query which projection specified from the source query specified. Typically used to fetch a typed view from a stored procedure source.

Async variant of FetchQueryFromSourceTElement(IDataAccessAdapter, DynamicQueryTElement, IRetrievalQuery) Fetches the query which projection specified from the source query specified. Typically used to fetch a typed view from a stored procedure source.

Fetches a scalar value using the query specified, and returns this value typed as TValue, using a cast. The query specified will be converted to a scalar query prior to execution.

Async variant of FetchScalarTValue(IDataAccessAdapter, DynamicQuery). Fetches a scalar value using the query specified, and returns this value typed as TValue, using a cast. The query specified will be converted to a scalar query prior to execution.

Async variant of FetchScalarTValue(IDataAccessAdapter, DynamicQuery). Fetches a scalar value using the query specified, and returns this value typed as TValue, using a cast. The query specified will be converted to a scalar query prior to execution.

Fetches the single object of the set returned by the query and returns that object. If there are no elements or more than 1 element, a NotSupportedException will be thrown.

Fetches the single entity of the set returned by the query and returns that entity. If there are no elements or more than 1 element, a NotSupportedException will be thrown.

Async variant of FetchSingleT(IDataAccessAdapter, DynamicQueryT). Fetches the single object of the set returned by the query and returns that object. If there are no elements or more than 1 element, a NotSupportedException will be thrown.

Async variant of FetchSingleTEntity(IDataAccessAdapter, EntityQueryTEntity). Fetches the single entity of the set returned by the query and returns that entity. If there are no elements or more than 1 element, a NotSupportedException will be thrown.

Async variant of FetchSingleT(IDataAccessAdapter, DynamicQueryT). Fetches the single object of the set returned by the query and returns that object. If there are no elements or more than 1 element, a NotSupportedException will be thrown.

Async variant of FetchSingleTEntity(IDataAccessAdapter, EntityQueryTEntity). Fetches the single entity of the set returned by the query and returns that entity. If there are no elements or more than 1 element, a NotSupportedException will be thrown.