DynamicQueryEngineBase Class |
Namespace: SD.LLBLGen.Pro.ORMSupportClasses
The DynamicQueryEngineBase type exposes the following members.
Name | Description | |
---|---|---|
DynamicQueryEngineBase |
Initializes a new instance of the DynamicQueryEngineBase class.
| |
DynamicQueryEngineBase(Boolean, Boolean) |
Creates a new DynamicQueryEngineBase instance.
|
Name | Description | |
---|---|---|
CommandTimeOut |
Gets / sets the command time out (in seconds). This is a global setting, so every Command object created after you've set this
property to a value will have that value as CommandTimeOut. Default is 30 seconds which is the ADO.NET default.
Do not set this property directly, but use the methods in the generated code to set this property.
| |
Creator |
Gets / sets creator
| |
DistinctFilteringPreferenceToUse |
Gets or sets the distinct filtering preference to use. The default value is the value of the global variable
DynamicQueryEngineBase.DistinctFilteringPreferenceDefault.
| |
FactoryToUse |
Gets the DbProviderFactory to use for this DQE.
| |
FunctionMappings |
Gets the function mappings for the particular DQE. These function mappings are static and therefore not changeable.
| |
PerCallCatalogNameOverwrites |
Gets / sets perCallCatalogNameOverwrites name pairs
| |
PerCallSchemaNameOverwrites |
Gets / sets perCallSchemaNameOverwrites name pairs
|
Name | Description | |
---|---|---|
AddSingleTargetElementToFromClause |
Adds a single target element to from clause. This is used when there's no join to add, but instead a single target. Takes care of hint emitting if required.
| |
AppendFieldExpressionAsValueForInsert |
Appends the field's expression as value to the specified valueFragments list for the specified insert query. It also appends the parameters to the
query as parameters (not anonymized yet)
| |
AppendFieldToValueFragmentsForInsert |
Appends the field (or its expresssion) to the value fragments of the query specified for insert.
| |
AppendGroupByClause |
Appends a GROUP BY clause with the contents of the filter if it's not null / empty, to the fragments object specified. Parameters are added
to the query specified
| |
AppendOrderByClause |
Appends an GROUP BY clause with the contents of the filter if it's not null / empty, to the fragments object specified. Parameters are added
to the query specified
| |
AppendResultsetFields |
Appends the resultset fields.
| |
AppendUpdateSetClauses(IListIEntityFieldCore, IListIFieldPersistenceInfo, QueryFragments, IList) |
Appends set clauses for an update query using the input specified to the destination list specified
| |
AppendUpdateSetClauses(IListIEntityFieldCore, IListIFieldPersistenceInfo, QueryFragments, IList, Boolean) |
Appends set clauses for an update query using the input specified to the destination list specified
| |
AppendWhereClause |
Appends a WHERE clause with the contents of the filter if it's not null / empty, to the fragments object specified. Parameters are added
to the query specified
| |
CheckIfFieldNeedsInsertAction |
Checks the if field needs insert action.
| |
ConstructFieldsToUpdateList |
Constructs the list of fields to update plus its corresponding fieldpersistenceinfo list.
| |
CreateActionQueryFromSQL |
Creates the action query from the sql query specified using the parameter values specified.
| |
CreateCommand |
Creates the command.
| |
CreateCommand(DbConnection) |
Creates a new DbCommand object and initializes it
| |
CreateCommand(String) |
Creates a new DbCommand object and initializes it
| |
CreateCommand(String, DbConnection) |
Creates a new DbCommand object and initializes it
| |
CreateDbSpecificCreator |
Creates a new IDbSpecificCreator and initializes it
| |
CreateDeleteDQ(IFieldPersistenceInfo, DbConnection, ListIPredicate) |
Creates a new Delete Query object which is ready to use.
| |
CreateDeleteDQ(IFieldPersistenceInfo, DbConnection, ListIPredicate, IPredicate, IRelationCollection) |
Creates a new Delete Query object which is ready to use.
| |
CreateInsertDQ(IEntityFields, DbConnection) |
Creates a new Insert Query object which is ready to use.
| |
CreateInsertDQ(IEntityFieldCore, IFieldPersistenceInfo, DbConnection) |
Creates a new Insert Query object which is ready to use.
| |
CreatePagingSelectDQ |
Creates a new Select Query which is ready to use, based on the specified select list and the specified set of relations.
If selectFilter is set to null, all rows are selected.
| |
CreateRealQueryAndParameters |
Creates the real sql query to execute from the query in string form and the parameters specified.
It updates 'query' with the constructed string and real DbParameter instances.
| |
CreateRetrievalQueryFromSQL |
Creates the retrieval query from the SQL query specified using the parameter values specified and is configured with the aspects specified.
| |
CreateRowCountDQ |
Creates a select query which will be executed as a scalar, and which will return a single value, the number of rows in the query
formed by the elements passed in.
| |
CreateSelectDQ(IEntityFieldCore, IFieldPersistenceInfo, DbConnection, IPredicate, Int64, ISortExpression, IGroupByCollection, Boolean) |
Creates a new Select Query which is ready to use. If selectFilter is set to null, all rows are selected.
| |
CreateSelectDQ(IEntityFieldCore, IFieldPersistenceInfo, DbConnection, IPredicate, Int64, ISortExpression, IRelationCollection, Boolean, IGroupByCollection) |
Creates a new Select Query which is ready to use, based on the specified select list and the specified set of relations.
If selectFilter is set to null, all rows are selected.
| |
CreateSelectDQ(IEntityFields, DbConnection, IPredicate, Int32, Int32, ISortExpression, IRelationCollection, Boolean, IGroupByCollection) |
Creates a new Select Query which is ready to use, based on the specified select list and the specified set of relations.
If selectFilter is set to null, all rows are selected.
| |
CreateSelectDQ(IEntityFieldCore, IFieldPersistenceInfo, DbConnection, IPredicate, Int32, Int32, ISortExpression, IRelationCollection, Boolean, IGroupByCollection) |
Creates a new Select Query which is ready to use, based on the specified select list and the specified set of relations.
If selectFilter is set to null, all rows are selected.
| |
CreateSelectDQ(IEntityFieldCore, IFieldPersistenceInfo, IRetrievalQuery, IPredicate, Int64, ISortExpression, IRelationCollection, Boolean, IGroupByCollection, Boolean, Boolean) |
Creates a new Select Query which is ready to use, based on the specified select list and the specified set of relations.
If selectFilter is set to null, all rows are selected.
| |
CreateSingleTargetDeleteDQ(IFieldPersistenceInfo, IActionQuery, IPredicate) |
Creates a new Delete Query object which is ready to use.
| |
CreateSingleTargetDeleteDQ(IFieldPersistenceInfo, IActionQuery, IPredicate, IRelationCollection) |
Creates a new Delete Query object which is ready to use.
| |
CreateSingleTargetDeleteDQUsingCorrelatedSubQuery |
Creates a new Delete Query object which is ready to use.
| |
CreateSingleTargetDeleteDQUsingKeywordClause |
Creates a new Delete Query object which is ready to use. Uses keyword clause (using keyword FROM/USING etc.)) for filtering
| |
CreateSingleTargetInsertDQ |
Creates a new Insert Query object which is ready to use.
| |
CreateSingleTargetUpdateDQ(IEntityFieldCore, IFieldPersistenceInfo, IActionQuery, IPredicate) |
Creates a new Update Query object which is ready to use. Only 'changed' EntityFieldCore fields are included in the update query.
Primary Key fields are never updated.
| |
CreateSingleTargetUpdateDQ(IEntityFieldCore, IFieldPersistenceInfo, IActionQuery, IPredicate, IRelationCollection) |
Creates a new Update Query object which is ready to use. Only 'changed' EntityFieldCore are included in the update query.
Primary Key fields are never updated.
| |
CreateSingleTargetUpdateDQUsingCorrelatedSubQuery |
Creates a new Update Query object which is ready to use. Only 'changed' EntityFieldCore are included in the update query.
Primary Key fields are never updated. Uses a correlated subquery for filtering
| |
CreateSingleTargetUpdateDQUsingFromClause |
Creates a new Update Query object which is ready to use. Only 'changed' EntityFieldCore are included in the update query.
Primary Key fields are never updated. Uses a FROM clause for filtering
| |
CreateSubqueryConnectionClausesDelete |
Produces a set of WHERE Clauses to use in the DELETE queries which have filters spanning multiple entities.
It produces one clause if it finds the deleteTable on the PK side and then stops and it produces n clauses if it finds deleteTable
on the FK side of n relations in relationsToWalk.
If the deleteTable is on the PK side, it produces a clause: deleteTableAlias.PKField1 = deleteTable.PKField1 AND... (for each field in the PK 1 clause)
If the deleteTable is on the FK side, it produces deleteTableAlias.Field1 = relatedEntityTable.Field1 AND ... clauses for each relation the table of the
persistence info is in.
| |
CreateSubqueryConnectionClausesUpdate |
Produces a set of WHERE Clauses to use in the UPDATE queries which have filters spanning multiple entities.
It produces one clause if it finds the updateTable on the PK side and then stops and it produces n clauses if it finds updateTable
on the FK side of n relations in relationsToWalk.
If the updateTable is on the PK side, it produces a clause: updatedTableAlias.PKField1 = updateTable.PKField1 AND... (for each field in the PK 1 clause)
If the updateTable is on the FK side, it produces updatedTableAlias.Field1 = relatedEntityTable.Field1 AND ... clauses for each relation the table of the
persistence info is in.
| |
CreateTvfCallQuery |
Creates a retrieval query for the tvfcall specified.
| |
CreateTvfFunctionNameFragmentList |
Creates the TVF function name fragment list. By default it will create 'FunctionName(parameterList)'. Override this method if
the DQE requires a different strategy to call a TVF, e.g. wrapping it.
| |
CreateUpdateDQ(IEntityFields, DbConnection, ListIPredicate) |
Creates a new Update Query object which is ready to use. Only 'changed' EntityFields are included in the update query.
Primary Key fields are never updated.
| |
CreateUpdateDQ(IEntityFieldCore, IFieldPersistenceInfo, DbConnection, ListIPredicate) |
Creates a new Update Query object which is ready to use. Only 'changed' EntityFieldCore fields are included in the update query.
| |
CreateUpdateDQ(IEntityFields, DbConnection, ListIPredicate, IPredicate, IRelationCollection) |
Creates a new Update Query object which is ready to use. Only 'changed' EntityFieldCore are included in the update query.
Primary Key fields are never updated.
| |
CreateUpdateDQ(IEntityFieldCore, IFieldPersistenceInfo, DbConnection, ListIPredicate, IPredicate, IRelationCollection) |
Creates a new Update Query object which is ready to use. Only 'changed' EntityFieldCore are included in the update query.
Primary Key fields are never updated.
| |
DetermineFilterToUse |
Determines the filter to use.
| |
DetermineIfDuplicatesWillOccur |
Determines if duplicates will occur.
| |
DetermineIfFieldAliasIsRequired |
Determines if field alias is required.
| |
DetermineObjectAliasToUseForSelectListField |
Determines the object alias to use for select list field.
| |
DetermineTargetAlias |
Determines the target alias to use for a single target FROM clause.
| |
Equals | Determines whether the specified object is equal to the current object. (Inherited from Object.) | |
Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) | |
GetCorrectFieldTypeBasedOnTypeSpecs |
Gets the correct field type, based on the type and lenght specified in the specified persistenceInfo
| |
GetHashCode | Serves as the default hash function. (Inherited from Object.) | |
GetNewCatalogName |
Gets the new name for the catalog, given the current name. If the current name is not found in the list of catalog name overwrites,
the current name is returned. This routine works on the catalog names specified in the config file.
| |
GetNewPerCallSequenceName |
Gets the new name of the sequence passed in. Default implementation overwrites schema name with a new name if the name
has been defined for overwriting. Works on the PerCallSchemaNameOverwrites set.
| |
GetNewPerCallStoredProcedureName |
Gets the new name of the stored procedure passed in. Overwrites schema and catalog name with a new name if these names
have been defined for overwriting. This routine works on the PerCallCatalogNameOverwrites and PerCallSchemaNameOverwrites names specified on this instance
| |
GetNewSchemaName |
Gets the new name for the schema, given the current name. If the current name is not found in the list of schema name overwrites,
the current name is returned. This routine works on the schema names specified in the config file.
| |
GetNewSequenceName |
Gets the new name of the sequence passed in. Default implementation overwrites schema name with a new name if the name
has been defined for overwriting.
| |
GetNewStoredProcedureName |
Gets the new name of the stored procedure passed in. Overwrites schema and catalog name with a new name if these names
have been defined for overwriting. This routine works on the catalog and schema names specified in the config file.
| |
GetNullInProjectionFragment |
Gets the fragment to use in a projection for a literal NULL. By default this is 'NULL', but some databases need extra processing around NULL. Do to so, override this method.
| |
GetTvfFunctionNameToUse |
Gets the table valued function name to use. By default it creates an object name from the elements specified like a table name.
| |
GetType | Gets the Type of the current instance. (Inherited from Object.) | |
HandleDistinctEmit |
Handles the emit of 'DISTINCT' into the query text and returns true if distinct was emitted or false if not.
| |
MakeParametersAnonymous(DbCommand) |
Makes the parameters anonymous in the passed in query. An anonymous parameter is '?', not '@foo'. It walks all parameters and replaces the
names of these parameters with "?" in the query text
| |
MakeParametersAnonymous(String, IList) |
Makes the parameters anonymous in the passed in query. An anonymous parameter is '?', not '@foo'. It walks all parameters and replaces the
names of these parameters with "?" in the query text
| |
MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) | |
ReAssembleStoredProcedureNameFragments |
Re-assembles the stored procedure name from the fragments specified
| |
ResetCreator |
Resets the creator object with a new one. Only used by DAO objects which keep a Dynamic Query Engine object alive.
| |
ToString | Returns a string that represents the current object. (Inherited from Object.) | |
WrapCommandInPagingQuery |
Wraps the command in the query specified in a paging query and adds necessary parameters to the command.
|
Name | Description | |
---|---|---|
DeleteQueryBufferLength |
Length of buffer in which Delete queries are generated
| |
DistinctFilteringPreferenceDefault |
The distinct filtering preference to use for all DQE instances.
| |
InsertQueryBufferLength |
Length of buffer in which Insert queries are generated
| |
SelectJoinQueryBufferLength |
Length of buffer in which Join constructs for select queries are generated
| |
SelectQueryBufferLength |
Length of buffer in which Select queries are generated
| |
SelectResultSetBufferLength |
Length of buffer in which resultset definitions for select queries are generated
| |
Switch |
The traceswitch used in the DQE. Set in the static constructor of the derived class.
| |
UpdateQueryBufferLength |
Length of buffer in which Update queries are generated
|