Click or drag to resize

DynamicQueryEngineBaseCreateSubqueryConnectionClausesDelete Method

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.

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 CreateSubqueryConnectionClausesDelete(
	string deleteTable,
	string deleteTableAlias,
	RelationCollection relationsToWalk
)

Parameters

deleteTable
Type: SystemString
name of table the caller is building the query for
deleteTableAlias
Type: SystemString
Alias for deleteTable. 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 delete queries.
See Also