！！！把sql转成linq的写法

cy_kvein 2017-03-23 02:20:54

SELECT SUM(AZCount),COUNT(DKCount) FROM EmployeeCommision where EmployeeId=xxx

...全文

859 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

Jenny_0417 2017-04-19

打赏
举报

丰云 2017-03-28

打赏
举报


//lambda表达式也不错哦
db.EmployeeCommisions.Where(p => p.EmployeeId == xxx).GroupBy(p=>p.EmployeeId).Select(p => new {
                    cnt = p.Count(),
                    total = p.Sum(q=>q.AZCount),
                });

Hertz_liu 2017-03-24

打赏
举报


from ec in EmployeeCommision 
where ec.EmployeeId == xx
group ec by ec.EmployeeId into g
select new 
{
	AZCount = g.Sum(x=>x.AZCount),
	DKCount = g.Count()
}