Click or drag to resize
DynamicQueryEngineBase.CreateRowCountDQ Method
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.

Namespace:  SD.LLBLGen.Pro.ORMSupportClasses
Assembly:  SD.LLBLGen.Pro.ORMSupportClasses (in SD.LLBLGen.Pro.ORMSupportClasses.dll) Version: 5.3.0.0 (5.3.0)
Syntax
public virtual IRetrievalQuery CreateRowCountDQ(
	IEntityFieldCore[] selectList,
	IFieldPersistenceInfo[] fieldsPersistenceInfo,
	DbConnection connectionToUse,
	IPredicate selectFilter,
	IRelationCollection relationsToWalk,
	bool allowDuplicates,
	IGroupByCollection groupByClause
)

Parameters

selectList
Type:SD.LLBLGen.Pro.ORMSupportClasses.IEntityFieldCore[]
list of IEntityFieldCore objects to select
fieldsPersistenceInfo
Type:SD.LLBLGen.Pro.ORMSupportClasses.IFieldPersistenceInfo[]
Array of IFieldPersistenceInfo objects to use to build the select query
connectionToUse
Type: System.Data.Common.DbConnection
The connection to use for the query
selectFilter
Type: SD.LLBLGen.Pro.ORMSupportClasses.IPredicate
A complete IPredicate implementing object which contains the filter for the rows to select. When set to null, no filtering is done, and all rows are returned.
relationsToWalk
Type: SD.LLBLGen.Pro.ORMSupportClasses.IRelationCollection
list of EntityRelation objects, which will be used to formulate a FROM clause with INNER JOINs.
allowDuplicates
Type: System.Boolean
Flag which forces the inclusion of DISTINCT if set to true. If the resultset contains fields of type ntext, text or image, no duplicate filtering is done.
groupByClause
Type: SD.LLBLGen.Pro.ORMSupportClasses.IGroupByCollection
The list of fields to group by on. When not specified or an empty collection is specified, no group by clause is added to the query. A check is performed for each field in the selectList. If a field in the selectList is not present in the groupByClause collection, an exception is thrown.

Return Value

Type: IRetrievalQuery
IRetrievalQuery instance which is ready to be used.
Exceptions
ExceptionCondition
ArgumentNullExceptionWhen selectList is null or fieldsPersistenceInfo is null
ArgumentExceptionWhen selectList contains no EntityFieldCore instances or fieldsPersistenceInfo is empty.
See Also