Click or drag to resize

IDataAccessAdapterGetDbCount Method (IEntityFields2, IRelationPredicateBucket)

Gets the number of rows returned by a query for the fields specified, using the filter and groupby clause specified.

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
Copy
int GetDbCount(
	IEntityFields2 fields,
	IRelationPredicateBucket filter
)

Parameters

fields
Type: SD.LLBLGen.Pro.ORMSupportClassesIEntityFields2
IEntityFields2 instance with the fields returned by the query to get the rowcount for
filter
Type: SD.LLBLGen.Pro.ORMSupportClassesIRelationPredicateBucket
filter to use by the query to get the rowcount for

Return Value

Type: Int32
the number of rows the query for the fields specified, using the filter, relations and groupbyClause specified.
Remarks
This method performs a SELECT COUNT(*) FROM (actual query) and executes that as a scalar query. This construct is not supported on Firebird. You can try to achieve the same results by using GetScalar and AggregateFunction.CountRow, though those results can differ from the result returned by GetDbCount if you use a group by clause.
See Also