C# LINQ to Entities does not recognize the method

Question

LINQ to Entities does not recognize the method 'Int64 getCount()' method, and this method cannot be translated into a store expression.

return query.OrderBy(e => e.Person.getCount(), sortDirection);

how can I rewrite this line ?

http://stackoverflow.com/questions/41244/dynamic-linq-orderby — Jahan, Dec 05 '12 at 21:04

score 4 · Accepted Answer · answered Dec 05 '12 at 21:02

4

Please use:

return query.ToList().OrderBy(e => e.Person.getCount(), sortDirection);

The case is EF tries to convert getCount() method to SQL. As it's custom method it can't be done so you should call ToList() to evaluate the expression and to make EF load objects from database to memory. Then linq can call you custom function to sort the data.

answered Dec 05 '12 at 21:02

petro.sidlovskyy

4,889
1
23
28

I think `AsEnumerable()` will be enough here, but +1 – Sergey Berezovskiy Dec 05 '12 at 21:07

C# LINQ to Entities does not recognize the method

1 Answers1