LLBLGen Pro v5.9 Runtime Framework Reference Manual
Namespaces
SD.LLBLGen.Pro Namespaces
SD.LLBLGen.Pro.ORMSupportClasses Namespaces
SD.LLBLGen.Pro.ORMSupportClasses
DynamicQueryEngineBase Class
DynamicQueryEngineBase Methods
AddSingleTargetElementToFromClause Method
AppendFieldExpressionAsValueForInsert Method
AppendFieldToValueFragmentsForInsert Method
AppendFromClause Method
AppendGroupByClause Method
AppendOrderByClause Method
AppendPostUpdateQueryInBatchFragments Method
AppendQueryHints Method
AppendResultsetFieldsToQuery Method
AppendUnionedQueries Method
AppendUpdateSetClauses Method
AppendWhereClause Method
CheckIfFieldNeedsInsertAction Method
CheckSelectListAndPersistenceInfoForSelect Method
ConstructFieldsToUpdateList Method
CreateActionQueryFromSQL Method
CreateCommand Method
CreateDbSpecificCreator Method
CreateDeleteDQ Method
CreateInsertDQ Method
CreatePagingSelectDQ Method
CreateRealQueryAndParameters Method
CreateRetrievalQueryFromSQL Method
CreateRowCountDQ Method
CreateSelectDQ Method
CreateSelectDQImpl Method
CreateSingleTargetDeleteDQ Method
CreateSingleTargetDeleteDQUsingCorrelatedSubQuery Method
CreateSingleTargetDeleteDQUsingKeywordClause Method
CreateSingleTargetInsertDQ Method
CreateSingleTargetUpdateDQ Method
CreateSingleTargetUpdateDQUsingCorrelatedSubQuery Method
CreateSingleTargetUpdateDQUsingFromClause Method
CreateSubqueryConnectionClausesDelete Method
CreateSubqueryConnectionClausesUpdate Method
CreateTvfCallQuery Method
CreateTvfFunctionNameFragmentList Method
CreateUpdateDQ Method
DetermineIfDuplicatesWillOccur Method
DetermineIfFieldAliasIsRequired Method
DetermineObjectAliasToUseForSelectListField Method
DetermineTargetAlias Method
GetCorrectFieldTypeBasedOnTypeSpecs Method
GetNewCatalogName Method
GetNewPerCallSequenceName Method
GetNewPerCallStoredProcedureName Method
GetNewSchemaName Method
GetNewSequenceName Method
GetNewStoredProcedureName Method
GetNullInProjectionFragment Method
GetTvfFunctionNameToUse Method
HandleDistinctEmit Method
MakeParametersAnonymous Method
PrepareQueryForBatchUpdates Method
ReAssembleFragments Method
ReAssembleStoredProcedureNameFragments Method
ResetCreator Method
UpdateAliasInUpdateTablePredicates Method
WrapCommandInPagingQuery Method
WrapQueryInBeginEndIfNecessary Method
Click or drag to resize

DynamicQueryEngineBaseCreateSingleTargetUpdateDQUsingCorrelatedSubQuery Method

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

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
Copy
protected void CreateSingleTargetUpdateDQUsingCorrelatedSubQuery(
	IEntityFieldCore[] fields,
	IFieldPersistenceInfo[] fieldsPersistenceInfo,
	IActionQuery query,
	IPredicate updateFilter,
	IRelationCollection relationsToWalk,
	bool addSetClauseParametersLast
)

Parameters

fields
Type: SD.LLBLGen.Pro.ORMSupportClassesIEntityFieldCore
Array of EntityFieldCore objects to use to build the insert query
fieldsPersistenceInfo
Type: SD.LLBLGen.Pro.ORMSupportClassesIFieldPersistenceInfo
Array of IFieldPersistenceInfo objects to use to build the update query
query
Type: SD.LLBLGen.Pro.ORMSupportClassesIActionQuery
The query object to fill.
updateFilter
Type: SD.LLBLGen.Pro.ORMSupportClassesIPredicate
A complete IPredicate implementing object which contains the filter for the rows to update
relationsToWalk
Type: SD.LLBLGen.Pro.ORMSupportClassesIRelationCollection
list of EntityRelation objects, which will be used to formulate a FROM clause with INNER JOINs.
addSetClauseParametersLast
Type: SystemBoolean
if set to it will add the update set clause parameters as the last set of parameters to the command object. Some ado.net providers need this (OleDb / Jet for example)
Exceptions
ExceptionCondition
ArgumentNullExceptionWhen fields is null or when updateFilter is null or when relationsToWalk is null or when fieldsPersistence is null
ArgumentExceptionWhen fields contains no EntityFieldCore instances or fieldsPersistenceInfo is empty.
See Also