关于LINQ to sql grou by 的问题
我用linq to sql 做了group by 源代码是这样的:
C# code
var s = from p in context.CarCCX_Info
where p.Werks == strWerks && p.Zupdate == strZupdate
group p by p.Matnr into g
select g;
我想返回的是list<实体类> 这种类型的,但是一直报错误
错误 1 无法将类型“System.Collections.Generic.List<System.Linq.IGrouping<string,YLPPENT.CarCCX_Info>>”隐式转换为“System.Collections.Generic.List<YLPPENT.CarCCX_Info>”
请问需要怎么解决啊?
------解决方案--------------------
var s = from p in context.CarCCX_Info
where p.Werks == strWerks && p.Zupdate == strZupdate
group p by p.Matnr into g
from x in g
select x;
------解决方案--------------------
OR:
var s = from p in context.CarCCX_Info
where p.Werks == strWerks && p.Zupdate == strZupdate
group p by p.Matnr into g
select g.First();
------解决方案--------------------
var s = from p in context.CarCCX_Info
where p.Werks == strWerks && p.Zupdate == strZupdate
group p by new { p.Matnr, p.Maktx, p.Werks, p.Ferth, p.Normt, p.ZColor }
into g
select new { iCount = g.Count(), g.Key, Items=g.ToList() };
另外,你只取到一条数据,就说明你只有1组啊。
------解决方案--------------------select new { } 返回的是新类,不再是你的List<你定义的类>
------解决方案--------------------group by 返回的也不再是你定义的类