Does this help? Remember that you need to add your own caching layer if needed on BF.

SortingElementCollection sortCollection = new SortingElementCollection();
sortCollection.Add(SortingElement.Empty);
                   
MetaClass m = DataContext.Current.MetaModel.MetaClasses["YourBusinessFoundationClassName"];
EntityObject[] sortedList = BusinessManager.List(m.Name, filterCollection.ToArray(), sortCollection.ToArray(), 0, int.MaxValue);

if (sortedList.Length > 0)

Hi Michael,

that code still load all entities, what I am looking for is a count of entities, so I do not, in the worst case, load 400.000+ contacts just to count how many there are.

As far as I know we don't have any built-in function to do that count. But you can implement it by a stored procedure. Is there any difficulty with that?

Regards.

/Q

I haven´t looked into this function before beacuse I never needed this But maybe this one will work even if it´s not recommended. Not sure about performance and what´s going on under the hood in this case.

http://world.episerver.com/Documentation/Items/Developers-Guide/EPiServer-Commerce/75/Business-Foundation/Working-with-SQL-Records/

Getting the Total Records Count
Call the CustomTableRow.GetTotalCount statement to return the total record count.

/M

@Quan

implementing a stored procedure would be doable, it just messes with the deployment routines we use, because then we would have to also deploy some sql scripts when we move code from dev -> staging -> prod. i guess we will have to do some raw sql as it seems like we can always rely on the meta class names to get the proper table names we need to count on and then work a bit with the metafield classes to get the proper column when we need to do filtering when counting.

@Michael

I just did some quick tests with this and it seems to do the trick, and I can also reuse my FilterElements. Will go with this solution, thanks :)

Great, I also took a quick test and this is what I did

Database database = SqlContext.Current.Database;
Mediachase.BusinessFoundation.Data.Sql.Management.Table contactTable = database.Tables["cls_Contact"];
FilterElementCollection fc = new FilterElementCollection();
int contactCount = CustomTableRow.GetTotalCount(contactTable, fc.ToArray());

Will generate the following query against the database

 SELECT COUNT(*)

FROM [cls_Contact] AS [t01]

/M

I did it a bit different(removed null checks for shorter example code) to prevent magic strings with table names:

MetaClass mc = DataContext.Current.GetMetaClass(ContactEntity.ClassName);

TableConfig contactConfig = mc.GetTableConfig();

int totalCount = CustomTableRow.GetTotalCount(contactConfig, new[] {filterelementOne, filterelementTwo});

but either way works.