Click or drag to resize

IDataAccessAdapter Interface

Interface for Data Access Adapter (DAA) objects. Instances of this interface are used as 'adapters' to work with databases. Adapter specific.

Namespace:  SD.LLBLGen.Pro.ORMSupportClasses
Assembly:  SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.9.0.0 (5.9.0)
Syntax
public interface IDataAccessAdapter : IDataAccessCore, 
	IDisposable, ITransactionController

The IDataAccessAdapter type exposes the following members.

Properties
  NameDescription
Public propertyActiveRecoveryStrategy
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.
Public propertyBatchSize
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.
Public propertyCommandTimeOut
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.
Public propertyConnectionString
Gets / sets the connection string to use for the connection with the database.
Public propertyFunctionMappings
Gets the function mappings for the DQE related to this object. These function mappings are static and therefore not changeable.
Public propertyInSystemTransaction
Gets a value indicating whether a System.Transactions transaction is going on. If not, false is returned.
Public propertyIsTransactionInProgress
Gets IsTransactionInProgress. True when there is a transaction in progress.
(Inherited from ITransactionController.)
Public propertyKeepConnectionOpen
Gets / sets KeepConnectionOpen, a flag used to keep open connections after a database action has finished.
Public propertyKeepTrackOfTransactionParticipants
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.
Public propertyParameterisedPrefetchPathThreshold
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.
Public propertyTransactionIsolationLevel
Gets / sets the isolation level a transaction should use. Setting this during a transaction in progress has no effect on the current running transaction.
Public propertyTransactionName
Gets the name of the transaction. Setting this during a transaction in progress has no effect on the current running transaction.
Public propertyUseRecoveryStrategy
Gets/sets the flag whether an active recovery strategy should be used. This property is true by default. If false, a query will executed outside the active recovery strategy set on this adapter.
Top
Methods
  NameDescription
Public methodCallActionStoredProcedure
Calls the specified action stored procedure in the database. If a transaction is in progress, it will participate in that transaction.
(Inherited from IDataAccessCore.)
Public methodCallActionStoredProcedureAsync
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.
(Inherited from IDataAccessCore.)
Public methodCallRetrievalStoredProcedure(String, DbParameter, DataSet)
Calls the specified retrieval stored procedure in the database. Fills the specified DataSet. Will participate in the transaction if a transaction is in progress.
(Inherited from IDataAccessCore.)
Public methodCallRetrievalStoredProcedure(String, DbParameter, DataTable)
Calls the specified retrieval stored procedure in the database. Fills the specified datatable. Will participate in the transaction if a transaction is in progress.
(Inherited from IDataAccessCore.)
Public methodCloseConnection
Closes the active connection. If no connection is available or the connection is closed, nothing is done.
Public methodCommit
Commits the controlled ado.net transaction
(Inherited from ITransactionController.)
Public methodCommitAsync
Async variant of commit.
(Inherited from ITransactionController.)
Public methodCreatePrimaryKeyFilter
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.
Public methodDeleteEntitiesDirectly(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.
Public methodDeleteEntitiesDirectly(Type, 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.
Public methodDeleteEntitiesDirectlyAsync(String, IRelationPredicateBucket)
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.
Public methodDeleteEntitiesDirectlyAsync(Type, IRelationPredicateBucket)
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.
Public methodDeleteEntitiesDirectlyAsync(String, IRelationPredicateBucket, CancellationToken)
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.
Public methodDeleteEntitiesDirectlyAsync(Type, IRelationPredicateBucket, CancellationToken)
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.
Public methodDeleteEntity(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.
Public methodDeleteEntity(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.
Public methodDeleteEntityAsync(IEntity2)
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.
Public methodDeleteEntityAsync(IEntity2, IPredicateExpression)
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.
Public methodDeleteEntityAsync(IEntity2, CancellationToken)
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.
Public methodDeleteEntityAsync(IEntity2, IPredicateExpression, CancellationToken)
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.
Public methodDeleteEntityCollection
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.
Public methodDeleteEntityCollectionAsync(IEntityCollection2)
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.
Public methodDeleteEntityCollectionAsync(IEntityCollection2, CancellationToken)
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.
Public methodDispose
Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources.
(Inherited from IDisposable.)
Public methodExecuteActionQuery
Executes the passed in action query and, if not null, runs it inside the passed in transaction.
Public methodExecuteActionQueryAsync
Async variant of ExecuteActionQuery(IActionQuery). Executes the passed in action query and, if not null, runs it inside the passed in transaction.
Public methodExecuteMultiRowDataTableRetrievalQuery(IRetrievalQuery, DbDataAdapter, IFieldPersistenceInfo)
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.
Public methodExecuteMultiRowDataTableRetrievalQuery(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.
Public methodExecuteMultiRowDataTableRetrievalQueryAsync
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.
Public methodExecuteMultiRowRetrievalQuery
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.
Public methodExecuteMultiRowRetrievalQueryAsync
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.
Public methodExecuteScalarQuery
Executes the passed in query as a scalar query and returns the value returned from this scalar execution.
Public methodExecuteSingleRowRetrievalQuery
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.
Public methodExecuteSQL
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
Public methodExecuteSQLAsync(String, Object)
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
Public methodExecuteSQLAsync(CancellationToken, String, Object)
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
Public methodFetchDataReader(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.
Public methodFetchDataReader(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.
Public methodFetchDataReader(IEntityFields2, IRelationPredicateBucket, CommandBehavior, Int32, Boolean)
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.
Public methodFetchDataReader(IEntityFields2, IRelationPredicateBucket, CommandBehavior, Int32, ISortExpression, Boolean)
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.
Public methodFetchDataReader(IEntityFields2, IRelationPredicateBucket, CommandBehavior, Int32, ISortExpression, Boolean, Int32, Int32)
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.
Public methodFetchDataReader(IEntityFields2, IRelationPredicateBucket, CommandBehavior, Int32, ISortExpression, IGroupByCollection, Boolean, Int32, Int32)
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.
Public methodFetchDataReaderAsync(CommandBehavior, QueryParameters, CancellationToken)
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.
Public methodFetchDataReaderAsync(IRetrievalQuery, CommandBehavior, CancellationToken)
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.
Public methodFetchEntity(IEntity2)
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)
Public methodFetchEntity(IEntity2, Context)
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)
Public methodFetchEntity(IEntity2, IPrefetchPath2)
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)
Public methodFetchEntity(IEntity2, IPrefetchPath2, Context)
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)
Public methodFetchEntity(IEntity2, IPrefetchPath2, Context, ExcludeIncludeFieldsList)
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).
Public methodFetchEntityCollection(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.
Public methodFetchEntityCollection(IEntityCollection2, IRelationPredicateBucket)
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
Public methodFetchEntityCollection(IEntityCollection2, ExcludeIncludeFieldsList, IRelationPredicateBucket)
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
Public methodFetchEntityCollection(IEntityCollection2, IRelationPredicateBucket, IPrefetchPath2)
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
Public methodFetchEntityCollection(IEntityCollection2, IRelationPredicateBucket, Int32)
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
Public methodFetchEntityCollection(IEntityCollection2, IRelationPredicateBucket, Int32, ISortExpression)
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.
Public methodFetchEntityCollection(IEntityCollection2, IRelationPredicateBucket, Int32, ISortExpression, IPrefetchPath2)
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.
Public methodFetchEntityCollection(IEntityCollection2, IRelationPredicateBucket, Int32, ISortExpression, IPrefetchPath2, ExcludeIncludeFieldsList)
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.
Public methodFetchEntityCollection(IEntityCollection2, IRelationPredicateBucket, Int32, ISortExpression, Int32, Int32)
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.
Public methodFetchEntityCollection(IEntityCollection2, IRelationPredicateBucket, Int32, ISortExpression, IPrefetchPath2, Int32, Int32)
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.
Public methodFetchEntityCollection(IEntityCollection2, IRelationPredicateBucket, Int32, ISortExpression, IPrefetchPath2, ExcludeIncludeFieldsList, Int32, Int32)
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.
Public methodFetchEntityCollectionAsync
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.
Public methodFetchEntityUsingUniqueConstraint(IEntity2, IPredicateExpression)
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.
Public methodFetchEntityUsingUniqueConstraint(IEntity2, IPredicateExpression, Context)
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.
Public methodFetchEntityUsingUniqueConstraint(IEntity2, IPredicateExpression, IPrefetchPath2)
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.
Public methodFetchEntityUsingUniqueConstraint(IEntity2, IPredicateExpression, IPrefetchPath2, Context)
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.
Public methodFetchEntityUsingUniqueConstraint(IEntity2, IPredicateExpression, IPrefetchPath2, Context, ExcludeIncludeFieldsList)
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.
Public methodFetchExcludedFieldBatch
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.
(Inherited from IDataAccessCore.)
Public methodFetchExcludedFieldBatchAsync
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.
(Inherited from IDataAccessCore.)
Public methodFetchExcludedFields(IEntity2, ExcludeIncludeFieldsList)
Loads the data for the excluded fields specified in the list of excluded fields into the entity passed in.
Public methodFetchExcludedFields(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.
Public methodFetchExcludedFieldsAsync(IEntity2, ExcludeIncludeFieldsList)
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.
Public methodFetchExcludedFieldsAsync(IEntityCollection2, ExcludeIncludeFieldsList)
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.
Public methodFetchExcludedFieldsAsync(IEntity2, ExcludeIncludeFieldsList, CancellationToken)
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.
Public methodFetchExcludedFieldsAsync(IEntityCollection2, ExcludeIncludeFieldsList, CancellationToken)
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.
Public methodFetchNewEntity(IEntityFactory2, IRelationPredicateBucket)
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)
Public methodFetchNewEntity(IEntityFactory2, IRelationPredicateBucket, Context)
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)
Public methodFetchNewEntity(IEntityFactory2, IRelationPredicateBucket, IPrefetchPath2)
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)
Public methodFetchNewEntity(IEntityFactory2, IRelationPredicateBucket, IPrefetchPath2, Context)
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)
Public methodFetchNewEntity(IEntityFactory2, IRelationPredicateBucket, IPrefetchPath2, Context, ExcludeIncludeFieldsList)
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)
Public methodFetchNewEntityTEntity(IRelationPredicateBucket)
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)
Public methodFetchNewEntityTEntity(IRelationPredicateBucket, Context)
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)
Public methodFetchNewEntityTEntity(IRelationPredicateBucket, IPrefetchPath2)
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)
Public methodFetchNewEntityTEntity(IRelationPredicateBucket, IPrefetchPath2, Context)
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)
Public methodFetchNewEntityTEntity(IRelationPredicateBucket, IPrefetchPath2, Context, ExcludeIncludeFieldsList)
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)
Public methodFetchProjection(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.
Public methodFetchProjection(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.
Public methodFetchProjection(ListIDataValueProjector, IGeneralDataProjector, IDataReader)
Projects the current resultset of the passed in datareader using the value projectors and the projector specified. The reader will be left open
Public methodFetchProjection(ListIDataValueProjector, IGeneralDataProjector, IDataReader, IRetrievalQuery)
Projects the current resultset of the passed in datareader using the value projectors and the projector specified. The reader will be left open
Public methodFetchProjection(ListIDataValueProjector, IGeneralDataProjector, IEntityFields2, IRelationPredicateBucket, Int32, Boolean)
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.
Public methodFetchProjection(ListIDataValueProjector, IGeneralDataProjector, IEntityFields2, IRelationPredicateBucket, Int32, ISortExpression, Boolean)
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.
Public methodFetchProjection(ListIDataValueProjector, IGeneralDataProjector, IEntityFields2, IRelationPredicateBucket, Int32, ISortExpression, Boolean, Int32, Int32)
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.
Public methodFetchProjection(ListIDataValueProjector, IGeneralDataProjector, IEntityFields2, IRelationPredicateBucket, Int32, ISortExpression, IGroupByCollection, Boolean, Int32, Int32)
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.
Public methodFetchProjectionT(IDataReader)
Projects the current resultset of the passed in datareader using the value projectors and the projector specified. The reader will be left open
Public methodFetchProjectionT(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.
Public methodFetchProjectionT(IDataReader, IRetrievalQuery)
Projects the current resultset of the passed in datareader using the value projectors and the projector specified. The reader will be left open
Public methodFetchProjectionAsync(ListIDataValueProjector, IGeneralDataProjector, IRetrievalQuery, CancellationToken)
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.
Public methodFetchProjectionAsync(ListIDataValueProjector, IGeneralDataProjector, QueryParameters, CancellationToken)
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.
Public methodFetchProjectionAsyncT(IRetrievalQuery)
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.
Public methodFetchProjectionAsyncT(IRetrievalQuery, CancellationToken)
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.
Public methodFetchQueryT(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.
Public methodFetchQueryT(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.
Public methodFetchQueryAsyncT(String, Object)
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.
Public methodFetchQueryAsyncT(CancellationToken, String, Object)
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.
Public methodFetchQueryAsyncT(PlainSQLFetchAspects, String, Object)
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.
Public methodFetchQueryAsyncT(CancellationToken, PlainSQLFetchAspects, String, Object)
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.
Public methodFetchScalarQueryT(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.
Public methodFetchScalarQueryT(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.
Public methodFetchScalarQueryAsyncT(String, Object)
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.
Public methodFetchScalarQueryAsyncT(CancellationToken, String, Object)
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.
Public methodFetchScalarQueryAsyncT(PlainSQLFetchAspects, String, Object)
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.
Public methodFetchScalarQueryAsyncT(CancellationToken, PlainSQLFetchAspects, String, Object)
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.
Public methodFetchTypedList(ITypedListLgp2)
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()
Public methodFetchTypedList(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()
Public methodFetchTypedList(ITypedListLgp2, IPredicateExpression)
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()
Public methodFetchTypedList(IEntityFields2, DataTable, IRelationPredicateBucket)
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()
Public methodFetchTypedList(IEntityFields2, DataTable, IRelationPredicateBucket, Boolean)
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()
Public methodFetchTypedList(IEntityFields2, DataTable, IRelationPredicateBucket, Int32, Boolean)
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()
Public methodFetchTypedList(ITypedListLgp2, IPredicateExpression, Int32, ISortExpression, Boolean)
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()
Public methodFetchTypedList(IEntityFields2, DataTable, IRelationPredicateBucket, Int32, ISortExpression, Boolean)
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()
Public methodFetchTypedList(IEntityFields2, DataTable, IRelationPredicateBucket, Int32, ISortExpression, Boolean, IGroupByCollection)
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()
Public methodFetchTypedList(ITypedListLgp2, IPredicateExpression, Int32, ISortExpression, Boolean, Int32, Int32)
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()
Public methodFetchTypedList(IEntityFields2, DataTable, IRelationPredicateBucket, Int32, ISortExpression, Boolean, IGroupByCollection, Int32, Int32)
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()
Public methodFetchTypedListAsync
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()
Public methodFetchTypedView(ITypedView2)
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.
Public methodFetchTypedView(DataTable, QueryParameters)
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.
Public methodFetchTypedView(IEntityFields2, DataTable)
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.
Public methodFetchTypedView(ITypedView2, IRetrievalQuery)
Fetches the typed view, using the query specified.
Public methodFetchTypedView(ITypedView2, Boolean)
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.
Public methodFetchTypedView(IEntityFields2, DataTable, Boolean)
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.
Public methodFetchTypedView(ITypedView2, IRelationPredicateBucket, Boolean)
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.
Public methodFetchTypedView(IEntityFields2, DataTable, IRelationPredicateBucket, Boolean)
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.
Public methodFetchTypedView(ITypedView2, IRelationPredicateBucket, Int32, Boolean)
Fetches the Typed View passed in from the persistent storage Doesn't apply any sorting. Use this routine to fill a TypedView object.
Public methodFetchTypedView(IEntityFields2, DataTable, IRelationPredicateBucket, Int32, Boolean)
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.
Public methodFetchTypedView(ITypedView2, IRelationPredicateBucket, Int32, ISortExpression, Boolean)
Fetches the Typed View passed in from the persistent storage
Public methodFetchTypedView(IEntityFields2, DataTable, IRelationPredicateBucket, Int32, ISortExpression, Boolean)
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.
Public methodFetchTypedView(ITypedView2, IRelationPredicateBucket, Int32, ISortExpression, Boolean, IGroupByCollection)
Fetches the Typed View passed in from the persistent storage
Public methodFetchTypedView(IEntityFields2, DataTable, IRelationPredicateBucket, Int32, ISortExpression, Boolean, IGroupByCollection)
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.
Public methodFetchTypedView(IEntityFields2, DataTable, IRelationPredicateBucket, Int32, ISortExpression, Boolean, IGroupByCollection, Int32, Int32)
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.
Public methodGetDbCount(IEntityCollection2, IRelationPredicateBucket)
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.
Public methodGetDbCount(IEntityFields2, IRelationPredicateBucket)
Gets the number of rows returned by a query for the fields specified, using the filter and groupby clause specified.
Public methodGetDbCount(IEntityCollection2, IRelationPredicateBucket, IGroupByCollection)
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.
Public methodGetDbCount(IEntityFields2, IRelationPredicateBucket, IGroupByCollection)
Gets the number of rows returned by a query for the fields specified, using the filter and groupby clause specified.
Public methodGetDbCount(IEntityFields2, IRelationPredicateBucket, IGroupByCollection, Boolean)
Gets the number of rows returned by a query for the fields specified, using the filter and groupby clause specified.
Public methodGetDbProviderFactoryInstance
Gets the DB provider factory instance.
(Inherited from IDataAccessCore.)
Public methodGetDbSpecificCreatorInstance
Gets the db specific creator instance for the database this object targets.
(Inherited from IDataAccessCore.)
Public methodGetScalar(IEntityField2, AggregateFunction)
Gets a scalar value, calculated with the aggregate and expression specified. the field specified is the field the expression and aggregate are applied on.
Public methodGetScalar(IEntityField2, IExpression, AggregateFunction)
Gets a scalar value, calculated with the aggregate and expression specified. the field specified is the field the expression and aggregate are applied on.
Public methodGetScalar(IEntityFields2, IPredicate, IGroupByCollection)
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.
Public methodGetScalar(IEntityField2, IExpression, AggregateFunction, IPredicate)
Gets a scalar value, calculated with the aggregate and expression specified. the field specified is the field the expression and aggregate are applied on.
Public methodGetScalar(IEntityFields2, IPredicate, IGroupByCollection, IRelationCollection)
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.
Public methodGetScalar(IEntityField2, IExpression, AggregateFunction, IPredicate, IGroupByCollection)
Gets a scalar value, calculated with the aggregate and expression specified. the field specified is the field the expression and aggregate are applied on.
Public methodGetScalar(IEntityField2, IExpression, AggregateFunction, IPredicate, IGroupByCollection, IRelationCollection)
Gets a scalar value, calculated with the aggregate and expression specified. the field specified is the field the expression and aggregate are applied on.
Public methodOpenConnection
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
Public methodOpenConnectionAsync
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
Public methodOpenConnectionAsync(CancellationToken)
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
Public methodProduceCorrectStoredProcedureName
Creates the correct stored procedure name, i.e. with catalog / schema name replaced properly.
(Inherited from IDataAccessCore.)
Public methodRollback
Rolls back the controlled ado.net transaction
(Inherited from ITransactionController.)
Public methodRollback(String)
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)
Public methodSaveEntity(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.
Public methodSaveEntity(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.
Public methodSaveEntity(IEntity2, Boolean, IPredicateExpression)
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.
Public methodSaveEntity(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.
Public methodSaveEntity(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.
Public methodSaveEntityAsync(IEntity2)
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.
Public methodSaveEntityAsync(IEntity2, Boolean)
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.
Public methodSaveEntityAsync(IEntity2, CancellationToken)
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.
Public methodSaveEntityAsync(IEntity2, Boolean, Boolean)
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.
Public methodSaveEntityAsync(IEntity2, Boolean, CancellationToken)
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.
Public methodSaveEntityAsync(IEntity2, Boolean, Boolean, CancellationToken)
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.
Public methodSaveEntityAsync(IEntity2, Boolean, IPredicateExpression, Boolean, CancellationToken)
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.
Public methodSaveEntityCollection(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.
Public methodSaveEntityCollection(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.
Public methodSaveEntityCollectionAsync(IEntityCollection2)
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.
Public methodSaveEntityCollectionAsync(IEntityCollection2, CancellationToken)
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.
Public methodSaveEntityCollectionAsync(IEntityCollection2, Boolean, Boolean)
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.
Public methodSaveEntityCollectionAsync(IEntityCollection2, Boolean, Boolean, CancellationToken)
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.
Public methodSaveTransaction
Creates a savepoint with the name savePointName in the current transaction. You can roll back to this savepoint using Rollback(String).
Public methodStartTransaction
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.
Public methodStartTransactionAsync(IsolationLevel, String)
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.
Public methodStartTransactionAsync(IsolationLevel, String, CancellationToken)
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.
Public methodUpdateEntitiesDirectly
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.
Public methodUpdateEntitiesDirectlyAsync(IEntity2, IRelationPredicateBucket)
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.
Public methodUpdateEntitiesDirectlyAsync(IEntity2, IRelationPredicateBucket, CancellationToken)
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.
Top
Events
  NameDescription
Public eventTransactionCommitted
Raised when Commit was successful.
(Inherited from ITransactionController.)
Public eventTransactionRolledback
Raised when Rollback was successful.
(Inherited from ITransactionController.)
Top
Extension Methods
  NameDescription
Public Extension MethodFetchAsDataReader
Fetches the query as an open data reader.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchAsDataReaderAsync
Async variant of FetchAsDataReader(IDataAccessAdapter, DynamicQuery, CommandBehavior). Fetches the query as an open data reader.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchAsDataTable(DynamicQuery)Overloaded.
Fetches the specified query into a new DataTable specified and returns that datatable.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchAsDataTable(DynamicQuery, DataTable)Overloaded.
Fetches the specified query into the DataTable specified and returns that datatable.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchAsDataTableAsync(DynamicQuery)Overloaded.
Async variant of FetchAsDataTable(IDataAccessAdapter, DynamicQuery). Fetches the specified query into a new DataTable specified and returns that datatable.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchAsDataTableAsync(DynamicQuery, DataTable)Overloaded.
Async variant of FetchAsDataTable(IDataAccessAdapter, DynamicQuery, DataTable). Fetches the specified query into the DataTable specified and returns that datatable.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchAsDataTableAsync(DynamicQuery, CancellationToken)Overloaded.
Async variant of FetchAsDataTable(IDataAccessAdapter, DynamicQuery). Fetches the specified query into a new DataTable specified and returns that datatable.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchAsDataTableAsync(DynamicQuery, DataTable, CancellationToken)Overloaded.
Async variant of FetchAsDataTable(IDataAccessAdapter, DynamicQuery, DataTable). Fetches the specified query into the DataTable specified and returns that datatable.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchAsProjection
Fetches the query as a projection, using the projector specified.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchAsProjectionAsync(DynamicQuery, IGeneralDataProjector)Overloaded.
Async variant of FetchAsProjection(IDataAccessAdapter, DynamicQuery, IGeneralDataProjector). Fetches the query as a projection, using the projector specified.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchAsProjectionAsync(DynamicQuery, IGeneralDataProjector, CancellationToken)Overloaded.
Async variant of FetchAsProjection(IDataAccessAdapter, DynamicQuery, IGeneralDataProjector). Fetches the query as a projection, using the projector specified.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchFirstT(DynamicQueryT)Overloaded.
Fetches the first object of the set returned by the query and returns that object, if any, otherwise null.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchFirstTEntity(EntityQueryTEntity)Overloaded.
Fetches the first entity of the set returned by the query and returns that entity, if any, otherwise null.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchFirstAsyncT(DynamicQueryT)Overloaded. (Defined by AdapterExtensionMethods.)
Public Extension MethodFetchFirstAsyncTEntity(EntityQueryTEntity)Overloaded. (Defined by AdapterExtensionMethods.)
Public Extension MethodFetchFirstAsyncT(DynamicQueryT, CancellationToken)Overloaded. (Defined by AdapterExtensionMethods.)
Public Extension MethodFetchFirstAsyncTEntity(EntityQueryTEntity, CancellationToken)Overloaded. (Defined by AdapterExtensionMethods.)
Public Extension MethodFetchQuery(DynamicQuery)Overloaded.
Fetches the query specified and returns the results in plain object arrays, one object array per returned row of the query specified.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchQueryTElement(DynamicQueryTElement)Overloaded.
Fetches the query specified and returns the results in a list of TElement objects, which are created using the projectorFunc of the query specified.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchQueryTEntity(EntityQueryTEntity)Overloaded.
Fetches the query specified on the adapter specified. Uses the TEntity type to produce an EntityCollection(Of TEntity) for the results to return
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchQueryTEntity, TCollection(EntityQueryTEntity, TCollection)Overloaded.
Fetches the query specified on the adapter specified into the collectionToFill specified.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchQueryAsync(DynamicQuery)Overloaded.
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.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchQueryAsync(DynamicQuery, CancellationToken)Overloaded.
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.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchQueryAsyncTElement(DynamicQueryTElement)Overloaded. (Defined by AdapterExtensionMethods.)
Public Extension MethodFetchQueryAsyncTEntity(EntityQueryTEntity)Overloaded. (Defined by AdapterExtensionMethods.)
Public Extension MethodFetchQueryAsyncTElement(DynamicQueryTElement, CancellationToken)Overloaded. (Defined by AdapterExtensionMethods.)
Public Extension MethodFetchQueryAsyncTEntity(EntityQueryTEntity, CancellationToken)Overloaded. (Defined by AdapterExtensionMethods.)
Public Extension MethodFetchQueryAsyncTEntity, TCollection(EntityQueryTEntity, TCollection)Overloaded. (Defined by AdapterExtensionMethods.)
Public Extension MethodFetchQueryAsyncTEntity, TCollection(EntityQueryTEntity, TCollection, CancellationToken)Overloaded. (Defined by AdapterExtensionMethods.)
Public Extension MethodFetchQueryFromSourceTElement
Fetches the query with the projection specified from the source query specified. Typically used to fetch a typed view from a stored procedure source.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchQueryFromSourceAsyncTElement(DynamicQueryTElement, IRetrievalQuery)Overloaded. (Defined by AdapterExtensionMethods.)
Public Extension MethodFetchQueryFromSourceAsyncTElement(DynamicQueryTElement, IRetrievalQuery, CancellationToken)Overloaded. (Defined by AdapterExtensionMethods.)
Public Extension MethodFetchScalarTValue
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.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchScalarAsyncTValue(DynamicQuery)Overloaded.
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.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchScalarAsyncTValue(DynamicQuery, CancellationToken)Overloaded.
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.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchSingleT(DynamicQueryT)Overloaded.
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.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchSingleTEntity(EntityQueryTEntity)Overloaded.
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.
(Defined by AdapterExtensionMethods.)
Public Extension MethodFetchSingleAsyncT(DynamicQueryT)Overloaded. (Defined by AdapterExtensionMethods.)
Public Extension MethodFetchSingleAsyncTEntity(EntityQueryTEntity)Overloaded. (Defined by AdapterExtensionMethods.)
Public Extension MethodFetchSingleAsyncT(DynamicQueryT, CancellationToken)Overloaded. (Defined by AdapterExtensionMethods.)
Public Extension MethodFetchSingleAsyncTEntity(EntityQueryTEntity, CancellationToken)Overloaded. (Defined by AdapterExtensionMethods.)
Top
See Also