IDao Interface

Gets / sets entityFactory to use

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

Adds the given fields to the database as a new entity.

Async variant of AddNew(IEntityFields, ITransaction). Adds the given fields to the database as a new entity.

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, ITransaction) 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.

Creates a new closed ADO.NET Connection object based on the connection string read from the *.config file of the appdomain. The connection string is stored in a key with the name defined in the constant connectionKeyString

Creates a new ADO.NET Connection

Creates a new ADO.NET DataAdapter.

Creates a new ADO.NET transaction

Deletes an entity from the persistent storage. Which entity is deleted is determined from the passed in EntityFields object.

Async variant of DeleteExisting(IEntityFields, ITransaction, IPredicate). Deletes an entity from the persistent storage. Which entity is deleted is determined from the passed in EntityFields object.

Deletes from the persistent storage all entities which match with the specified filter, formulated in the predicate or predicate expression definition, of the type and subtypes of the entity owning this DAO.

Deletes from the persistent storage all entities of the type this DAO is for which match with the specified filter, formulated in the predicate or predicate expression definition.

Async variant of DeleteMulti(ITransaction, IPredicate, IRelationCollection). Deletes from the persistent storage all 'Employee' entities which match with the specified filter, formulated in the predicate or predicate expression definition.

Determines which connection to use: the connection held by the passed in transaction (if any) or a new one (if no Transaction was passed in)

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

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

Executes the passed in retrieval query and, if not null, runs it inside the passed in transaction. Used to read 1 row.

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.

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

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

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

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(IEntity, ITransaction, ExcludeIncludeFieldsList). Loads the data for the excluded fields specified in the list of excluded fields into the entity passed in.

Async variant of FetchExcludedFields(IEntityCollection, ITransaction, 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(IEntity, ITransaction, ExcludeIncludeFieldsList). Loads the data for the excluded fields specified in the list of excluded fields into the entity passed in.

Async variant of FetchExcludedFields(IEntityCollection, ITransaction, 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.

Reads the data of an entity into the specified EntityFields object and returns that object. Which data is read is determined using the passed in Primary Key field(s). If specified, it also processes the prefetch path.

Performs the polymorphic entity fetch for the entity type of this DAO. It will produce an entity of that type or a subtype of that type, based on the values retrieved, or an empty entity if not found. The passed in fields object has its PK fields filled, which are used to produce a PK filter.

Executes the specified plain SQL query using this DAO 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 DAO 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(ITransaction, String, Object) Executes the specified plain SQL query using this DAO 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(ITransaction, String, Object) Executes the specified plain SQL query using this DAO 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, ITransaction, String, Object) Executes the specified plain SQL query using this DAO 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, ITransaction, String, Object) Executes the specified plain SQL query using this DAO 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 DAO 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 DAO 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(ITransaction, String, Object). Executes the specified plain SQL query using this DAO 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(ITransaction, String, Object). Executes the specified plain SQL query using this DAO 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, ITransaction, String, Object). Executes the specified plain SQL query using this DAO 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, ITransaction, String, Object). Executes the specified plain SQL query using this DAO 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.

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 specified, 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 specified, 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 specified, 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 specified, 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 specified, 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 specified, the command is wired to the transaction.

Async variant of GetAsDataReader(ITransaction, 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 specified, the command is wired to the transaction.

Async variant of GetAsDataReader(ITransaction, 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 specified, the command is wired to 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

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 using the value projectors and the projector specified. IF a transaction is specified, 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 specified, 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 specified, 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 specified, 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 specified, 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 specified, 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

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 specified, the command is wired to the transaction and executed inside the transaction.

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

Async variant of GetAsProjection(ListIDataValueProjector, IGeneralDataProjector, ITransaction, 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 specified, the command is wired to the transaction and executed inside the transaction. The projection results will be stored in the projector.

Async variant of GetAsProjectionT(IRetrievalQuery) Executes the passed in retrievalquery and projects the resultset onto instances of T (each row is materialized into an instance of T).

Async variant of GetAsProjectionT(IRetrievalQuery) Executes the passed in retrievalquery and projects the resultset onto instances of T (each row is materialized into an instance of T).

Async variant of GetAsProjectionT(ITransaction, 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 specified, the command is wired to the transaction and executed inside the transaction.

Async variant of GetAsProjectionT(ITransaction, 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 specified, the command is wired to the transaction and executed inside the transaction.

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.

Retrieves in the calling entity collection object all entity objects which match with the specified filter, formulated in the predicate or predicate expression definition, using the passed in relations to construct the total query. It will also prefetch all related objects defined in the prefetchpath specified.

Retrieves in the calling Collection object all Entity objects which match with the specified filter, formulated in the predicate or predicate expression definition, using the passed in relations to construct the total query.

Retrieves in the calling Collection object all Entity objects which match with the specified filter, formulated in the predicate or predicate expression definition, using the passed in relations to construct the total query.

Retrieves in the calling Collection object all Entity objects which match with the specified filter, formulated in the predicate or predicate expression definition, using the passed in relations to construct the total query.

Retrieves entities of the type this dao is for in a datatable which match the specified filter. It will always create a new connection to the database.

Retrieves the results of the query specified into the tableToFill.

Retrieves entities of the type this dao is for in a datatable which match the specified filter. It will always create a new connection to the database.

Retrieves entities of the type this dao is for in a datatable which match the specified filter. It will always create a new connection to the database.

Retrieves rows in the datatable provided which match the specified filter, containing the fields specified. It will always create a new connection to the database.

Retrieves rows in the datatable provided which match the specified filter, containing the fields specified. It will always create a new connection to the database.

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.

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.

Inserts all rows matching the select query into the target of the entity type this DAO is for. Which fields are inserted is defined by the select query. Sequenced fields are taken care of if they're not specified in the select query. This method will result in an INSERT INTO entityTarget (field1, field2...) SELECT ... statement.

Async variant of InsertMulti(ITransaction, DynamicQuery) Inserts all rows matching the select query into the target of the entity type this DAO is for. Which fields are inserted is defined by the select query. Sequenced fields are taken care of if they're not specified in the select query. This method will result in an INSERT INTO entityTarget (field1, field2...) SELECT ... statement.

Reads the data of the entity passed in, and returns that object. Which data is read is determined using the set Primary Key field(s). If specified, it also processes the prefetch path.

Updates an existing entity using the given fields.

Updates an existing entity using the given fields.

Async variant of UpdateExisting(IEntityFields, ITransaction, IPredicate). Updates an existing entity using the given fields.

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.

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 UpdateMulti(IEntity, ITransaction, IPredicate, IRelationCollection). 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.

Fetches the query as an open data reader.

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

Async variant of FetchAsDataReader(IDao, ITransaction, 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 a new DataTable specified and returns that datatable.

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

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

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

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

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

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

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

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

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

Async variant of FetchAsDataTable(IDao, DynamicQuery, DataTable, ITransaction). 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(IDao, ITransaction, DynamicQuery, IGeneralDataProjector). Fetches the query as a projection, using the projector specified.

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

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 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 and returns the results in a list of TElement objects, which are created using the projectorFunc of the query specified.

Async variant of FetchQuery(IDao, 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(IDao, 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(IDao, DynamicQuery, ITransaction). 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(IDao, DynamicQuery, ITransaction). 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(IDao, 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 FetchQueryTElement(IDao, 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 FetchQueryTElement(IDao, DynamicQueryTElement, ITransaction). 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 FetchQueryTElement(IDao, DynamicQueryTElement, ITransaction). 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 which projection specified from the source query specified. Typically used to fetch a typed view from a stored procedure source.

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(IDao, 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(IDao, 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(IDao, DynamicQueryTElement, IRetrievalQuery, ITransaction) 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(IDao, DynamicQueryTElement, IRetrievalQuery, ITransaction) Fetches the query which projection specified from the source query specified. Typically used to fetch a typed view from a stored procedure source.

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

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

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

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

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

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

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 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 GetScalarTValue(IDao, 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 GetScalarTValue(IDao, DynamicQuery, ITransaction). 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 GetScalarTValue(IDao, 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 GetScalarTValue(IDao, DynamicQuery, ITransaction). 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 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 GetSingleT(IDao, 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 GetSingleT(IDao, 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 GetSingleT(IDao, DynamicQueryT, ITransaction). 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 GetSingleT(IDao, DynamicQueryT, ITransaction). 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.