Click or drag to resize
DynamicQueryEngine Class
DynamicQueryEngine for Oracle.
Inheritance Hierarchy

Namespace: SD.LLBLGen.Pro.DQE.Oracle
Assemblies:  SD.LLBLGen.Pro.DQE.OracleMS (in SD.LLBLGen.Pro.DQE.OracleMS.dll) Version: 5.0.0.0 (5.0.0)
  SD.LLBLGen.Pro.DQE.OracleODPNet (in SD.LLBLGen.Pro.DQE.OracleODPNet.dll) Version: 5.0.0.0 (5.0.0)
Syntax
public class DynamicQueryEngine : DynamicQueryEngineBase

The DynamicQueryEngine type exposes the following members.

Constructors
  NameDescription
Public methodDynamicQueryEngine
Initializes a new instance of the DynamicQueryEngine class.
Top
Properties
  NameDescription
Public propertyCreator
Gets / sets creator
(Inherited from DynamicQueryEngineBase.)
Public propertyStatic memberDefaultCompatibilityLevel
Sets the default compatibility level used by the DQE. Default is Oracle9i10g11g. This is a global setting. Compatibility level influences the query generated for paging and identity sequence usage in inserts.
Public propertyDistinctFilteringPreferenceToUse
Gets or sets the distinct filtering preference to use. The default value is the value of the global variable DynamicQueryEngineBase.DistinctFilteringPreferenceDefault.
(Inherited from DynamicQueryEngineBase.)
Public propertyFactoryToUse
Gets the DbProviderFactory to use for this DQE.
(Inherited from DynamicQueryEngineBase.)
Public propertyFunctionMappings
Gets the function mappings for the particular DQE. These function mappings are static and therefore not changeable.
(Overrides DynamicQueryEngineBaseFunctionMappings.)
Public propertyPerCallCatalogNameOverwrites
Gets / sets perCallCatalogNameOverwrites name pairs
(Inherited from DynamicQueryEngineBase.)
Public propertyPerCallSchemaNameOverwrites
Gets / sets perCallSchemaNameOverwrites name pairs
(Inherited from DynamicQueryEngineBase.)
Top
Methods
  NameDescription
Protected methodAppendFieldExpressionAsValueForInsert
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)
(Inherited from DynamicQueryEngineBase.)
Protected methodAppendFieldToValueFragmentsForInsert
Appends the field (or its expresssion) to the value fragments of the query specified for insert.
(Inherited from DynamicQueryEngineBase.)
Protected methodAppendGroupByClause
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
(Inherited from DynamicQueryEngineBase.)
Protected methodAppendOrderByClause
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
(Inherited from DynamicQueryEngineBase.)
Protected methodAppendResultsetFields
Appends the resultset fields.
(Inherited from DynamicQueryEngineBase.)
Protected methodAppendUpdateSetClauses(IListIEntityFieldCore, IListIFieldPersistenceInfo, DelimitedStringList, IList)
Appends set clauses for an update query using the input specified to the destination list specified
(Inherited from DynamicQueryEngineBase.)
Protected methodAppendUpdateSetClauses(IListIEntityFieldCore, IListIFieldPersistenceInfo, DelimitedStringList, IList, Boolean)
Appends set clauses for an update query using the input specified to the destination list specified
(Inherited from DynamicQueryEngineBase.)
Protected methodAppendWhereClause
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
(Inherited from DynamicQueryEngineBase.)
Protected methodCheckIfFieldNeedsInsertAction
Checks the if field needs insert action.
(Inherited from DynamicQueryEngineBase.)
Protected methodConstructFieldsToUpdateList
Constructs the list of fields to update plus its corresponding fieldpersistenceinfo list.
(Inherited from DynamicQueryEngineBase.)
Protected methodCreateCommand
Creates the command.
(Inherited from DynamicQueryEngineBase.)
Protected methodCreateCommand(DbConnection)
Creates a new DbCommand object and initializes it
(Inherited from DynamicQueryEngineBase.)
Protected methodCreateCommand(String)
Creates a new DbCommand object and initializes it
(Inherited from DynamicQueryEngineBase.)
Protected methodCreateCommand(String, DbConnection)
Creates a new DbCommand object and initializes it
(Inherited from DynamicQueryEngineBase.)
Protected methodCreateDbSpecificCreator
Creates a new IDbSpecificCreator and initializes it
(Overrides DynamicQueryEngineBaseCreateDbSpecificCreator.)
Public methodCreateDeleteDQ(IFieldPersistenceInfo, DbConnection, ListIPredicate)
Creates a new Delete Query object which is ready to use.
(Inherited from DynamicQueryEngineBase.)
Public methodCreateDeleteDQ(IFieldPersistenceInfo, DbConnection, ListIPredicate, IPredicate, IRelationCollection)
Creates a new Delete Query object which is ready to use.
(Inherited from DynamicQueryEngineBase.)
Public methodCreateInsertDQ(IEntityFields, DbConnection)
Creates a new Insert Query object which is ready to use.
(Inherited from DynamicQueryEngineBase.)
Public methodCreateInsertDQ(IEntityFieldCore, IFieldPersistenceInfo, DbConnection)
Creates a new Insert Query object which is ready to use.
(Inherited from DynamicQueryEngineBase.)
Protected methodCreatePagingSelectDQ
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.
(Overrides DynamicQueryEngineBaseCreatePagingSelectDQ(IEntityFieldCore, IFieldPersistenceInfo, DbConnection, IPredicate, Int32, Int32, ISortExpression, IRelationCollection, Boolean, IGroupByCollection).)
Public methodCreateRowCountDQ
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.
(Inherited from DynamicQueryEngineBase.)
Public methodCreateSelectDQ(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.
(Inherited from DynamicQueryEngineBase.)
Public methodCreateSelectDQ(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.
(Inherited from DynamicQueryEngineBase.)
Public methodCreateSelectDQ(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.
(Inherited from DynamicQueryEngineBase.)
Public methodCreateSelectDQ(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.
(Inherited from DynamicQueryEngineBase.)
Protected methodCreateSelectDQ(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.
(Overrides DynamicQueryEngineBaseCreateSelectDQ(IEntityFieldCore, IFieldPersistenceInfo, IRetrievalQuery, IPredicate, Int64, ISortExpression, IRelationCollection, Boolean, IGroupByCollection, Boolean, Boolean).)
Protected methodCreateSingleTargetDeleteDQ(IFieldPersistenceInfo, IActionQuery, IPredicate)
Creates a new Delete Query object which is ready to use.
(Inherited from DynamicQueryEngineBase.)
Protected methodCreateSingleTargetDeleteDQ(IFieldPersistenceInfo, IActionQuery, IPredicate, IRelationCollection)
Creates a new Delete Query object which is ready to use.
(Overrides DynamicQueryEngineBaseCreateSingleTargetDeleteDQ(IFieldPersistenceInfo, IActionQuery, IPredicate, IRelationCollection).)
Protected methodCreateSingleTargetDeleteDQUsingCorrelatedSubQuery
Creates a new Delete Query object which is ready to use.
(Inherited from DynamicQueryEngineBase.)
Protected methodCreateSingleTargetDeleteDQUsingKeywordClause
Creates a new Delete Query object which is ready to use. Uses keyword clause (using keyword FROM/USING etc.)) for filtering
(Inherited from DynamicQueryEngineBase.)
Protected methodCreateSingleTargetInsertDQ
Creates a new Insert Query object which is ready to use.
(Overrides DynamicQueryEngineBaseCreateSingleTargetInsertDQ(IEntityFieldCore, IFieldPersistenceInfo, IActionQuery, DictionaryIEntityFieldCore, DbParameter).)
Protected methodCreateSingleTargetUpdateDQ(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.
(Inherited from DynamicQueryEngineBase.)
Protected methodCreateSingleTargetUpdateDQ(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.
(Overrides DynamicQueryEngineBaseCreateSingleTargetUpdateDQ(IEntityFieldCore, IFieldPersistenceInfo, IActionQuery, IPredicate, IRelationCollection).)
Protected methodCreateSingleTargetUpdateDQUsingCorrelatedSubQuery
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
(Inherited from DynamicQueryEngineBase.)
Protected methodCreateSingleTargetUpdateDQUsingFromClause
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
(Inherited from DynamicQueryEngineBase.)
Protected methodCreateSubqueryConnectionClausesDelete
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.
(Inherited from DynamicQueryEngineBase.)
Protected methodCreateSubqueryConnectionClausesUpdate
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.
(Inherited from DynamicQueryEngineBase.)
Protected methodCreateTvfCallQuery
Creates a retrieval query for the tvfcall specified.
(Inherited from DynamicQueryEngineBase.)
Protected methodCreateTvfFunctionNameFragmentList
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.
(Overrides DynamicQueryEngineBaseCreateTvfFunctionNameFragmentList(TableValuedFunctionCall, DelimitedStringList).)
Public methodCreateUpdateDQ(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.
(Inherited from DynamicQueryEngineBase.)
Public methodCreateUpdateDQ(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.
(Inherited from DynamicQueryEngineBase.)
Public methodCreateUpdateDQ(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.
(Inherited from DynamicQueryEngineBase.)
Public methodCreateUpdateDQ(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.
(Inherited from DynamicQueryEngineBase.)
Protected methodDetermineFilterToUse
Determines the filter to use.
(Inherited from DynamicQueryEngineBase.)
Protected methodDetermineIfDuplicatesWillOccur
Determines if duplicates will occur.
(Inherited from DynamicQueryEngineBase.)
Protected methodDetermineIfFieldAliasIsRequired
Determines if field alias is required.
(Inherited from DynamicQueryEngineBase.)
Protected methodDetermineObjectAliasToUseForSelectListField
Determines the object alias to use for select list field.
(Inherited from DynamicQueryEngineBase.)
Protected methodDetermineTargetAlias
Determines the target alias to use for a single target FROM clause.
(Inherited from DynamicQueryEngineBase.)
Public methodEquals
Determines whether the specified object is equal to the current object.
(Inherited from Object.)
Protected methodFinalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object.)
Protected methodGetCorrectFieldTypeBasedOnTypeSpecs
Gets the correct field type, based on the type and lenght specified in the specified persistenceInfo
(Inherited from DynamicQueryEngineBase.)
Public methodGetHashCode
Serves as the default hash function.
(Inherited from Object.)
Public methodGetNewCatalogName
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.
(Inherited from DynamicQueryEngineBase.)
Public methodGetNewPerCallSequenceName
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.
(Inherited from DynamicQueryEngineBase.)
Public methodGetNewPerCallStoredProcedureName
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
(Inherited from DynamicQueryEngineBase.)
Public methodGetNewSchemaName
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.
(Overrides DynamicQueryEngineBaseGetNewSchemaName(String).)
Public methodGetNewSequenceName
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.
(Inherited from DynamicQueryEngineBase.)
Public methodGetNewStoredProcedureName
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.
(Inherited from DynamicQueryEngineBase.)
Protected methodGetNullInProjectionFragment
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.
(Inherited from DynamicQueryEngineBase.)
Protected methodGetTvfFunctionNameToUse
Gets the table valued function name to use. By default it creates an object name from the elements specified like a table name.
(Inherited from DynamicQueryEngineBase.)
Public methodGetType
Gets the Type of the current instance.
(Inherited from Object.)
Protected methodHandleDistinctEmit
Handles the emit of 'DISTINCT' into the query text and returns true if distinct was emitted or false if not.
(Inherited from DynamicQueryEngineBase.)
Protected methodMakeParametersAnonymous(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
(Inherited from DynamicQueryEngineBase.)
Protected methodMakeParametersAnonymous(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
(Inherited from DynamicQueryEngineBase.)
Protected methodMemberwiseClone
Creates a shallow copy of the current Object.
(Inherited from Object.)
Protected methodReAssembleStoredProcedureNameFragments
Re-assembles the stored procedure name from the fragments specified
(Overrides DynamicQueryEngineBaseReAssembleStoredProcedureNameFragments(String).)
Protected methodResetCreator
Resets the creator object with a new one. Only used by DAO objects which keep a Dynamic Query Engine object alive.
(Inherited from DynamicQueryEngineBase.)
Public methodToString
Returns a string that represents the current object.
(Inherited from Object.)
Top
See Also