asp.net-mvc - ASP.NET MVC LINQ 查询

Question

当我使用查询时

var NewMatchs = (from x in entity.matches select x).LastOrDefault();

我得到这样的错误

LINQ to Entities does not recognize the method 'SocialSports.Models.match LastOrDefaultmatch' method, and this method cannot be translated into a store expression.

我的代码有什么问题？？？

谢谢...

Answer 1

LastOrDefault Linq to Entities 不支持。您可以使用以下方法实现相同的效果:

var lastmatch = (from x in entity.matches select x)
                      // Assuming you have some kind of timestamp
                     .OrderByDescending(s => s.Date) 
                     .FirstOrDefault();