与存储库和实体框架分组 [英] group by with repository and entity framework

问题描述

我有这个实体框架代码：

i have this entity framework code:

repository.GetObjectQuery(Of COUNL1)().Where(Function(a) a.CDATE >= "2012/01/01" And a.CDATE <= "2012/12/01" And COID = 88 ).GroupBy(Function(m) m.CDATE).Select(Function(n) New PointXY With {.Y = n.Sum(Function(k) k.TOTALVH), .X = n.First().CDATE}).ToList

这个错误：

this error accoured:

Only parameterless constructors and initializers are supported in LINQ to Entities.

描述：

i想要CDATE的组和TOTALVH的总和并把它放在PointXY类这样的

description:
i want group by CDATE and sum of TOTALVH and put it in PointXY Class Like this

PointXY {.Y = Sum(TOTALVH), .X = CDATE})

sql查询：

sql Query :

SELECT        SUM(TOTALVH) AS EXPR1, CDATE
FROM            COUNL1
WHERE        (CDATE >= '2012/01/01') AND (CDATE <= '2012/12/01') AND   (COID  = 88)
GROUP BY CDATE

请帮助我，谢谢大家。

please help me,thanks all.

推荐答案

var data = from tablename.groupby（a => a.cdate）

.select（al => new datamodle {expr1 = sum（al.first（）。taotalvj，cdate = al.first（）。cdate）}）;

var data = from a in tablename.groupby(a=>a.cdate)
.select (al => new datamodle{expr1=sum(al.first().taotalvj,cdate=al.first().cdate) });

这篇关于与存储库和实体框架分组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！