Solve the error LINQ to Entities does not recognize the method Last().
Hi all, in this post I will show you how to resolve a little problem when using ADO.net entity framework
Details of the problem: when trying to use the method last() to have the last record in the database table using thi code :
databaseEntities db = new databaseEntities(); UserSet user = new UserSet(); user = (from e1 in db.UserSet select e1).Last();
it throws an exception that says :
LINQ to Entities does not recognize the method ‘Myapp.UserSet Last[UserSet](System.Linq.IQueryable`1[Myapp.UserSet])’ method, and this method cannot be translated into a store expression.
Solution:
replace the instruction : user = (from e1 in db.UserSet select e1).Last(); with user = (from e1 in db.UserSet select e1).ToList().Last(); and it will work properly
Hope that was helpful.