Record Count

BIZ TMS Aurelius
1

Is there an inexpensive way to get the Record Count?


For Example:
MyCriteria.List<TCustomer>;

it will return a List that I could use the Count property.

However I have the time cost of list loading and the object to be freed after use.

I want to know the result in records of a query before loading it to the list. Eventually I need to change to strategy when dealing with the query according the amount of returned records.

And even to know if a table is empty or not.

Thank you....

Eduardo
2

Hi Eduardo, you must use the traditional approach of executing a previous SQL with a Count before executing the SQL which retrieves all the data. Create a criteria with a count grouping, Aurelius criteria allows grouping.