Click or drag to resize

DynamicQueryEngineBaseCreateSubqueryConnectionClausesUpdate Method

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.

Namespace:  SD.LLBLGen.Pro.ORMSupportClasses
Assembly:  SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.11.0.0 (5.11.23.1114)
Syntax
protected virtual string CreateSubqueryConnectionClausesUpdate(
	string updatedEntity,
	string updatedTableAlias,
	RelationCollection relationsToWalk
)

Parameters

updatedEntity
Type: SystemString
The entity being updated. This entity is already in the relation list, and should be tied to entities inside the relation list
updatedTableAlias
Type: SystemString
Alias for updatedEntity. To use in the clauses
relationsToWalk
Type: SD.LLBLGen.Pro.ORMSupportClassesRelationCollection
relations used in the query build up by caller

Return Value

Type: String
predicates to use in WHERE clause in subquery in mentioned update queries.
See Also