正文

报错：System.NotSupportedException: LINQ to Entities does not recognize the method

IP云
IP云V管理员/3 阅读
09/22
提示：扫一扫查出行
【扫一扫了解最新限行尾号】
复制提示

报错：System.NotSupportedException: LINQ to Entities does not recognize the method ...... get_Item(Int32)' method, and this method cannot be translated into a store expression.

在控制器中有如下一段代码：

var tempList = SomeService.LoadEntities(c => c.DelFlag == (short)DelFlagEnum.Normal);

var result = from l in tempList

select new { n = l.Name, a = l.Age };

LoadEntities方法返回的类型是IQueryable<T>，如果要对集合用Select方法，在用Select方法之前需要ToList一下。

修改成：

var result = from l in tempList.ToList()

select new { n = l.Name, a = l.Age };