求教转化成ef形式怎么写

[冷雪液]

select count(*) as num,a.type,b.FullName from [dbo].[Assigneds] a,[dbo].[Depts] b 
where a.DeptID=b.ID and [Jbrq]>='2017-10-22' and [Jbrq]<='2017-10-22' 
group by b.ID,b.FullName,a.type

没法回答你，只能在这里回答你了

from a in Assigneds
from b in Depts
where a.DeptID==b.ID && [Jbrq]>='2017-10-22' && [Jbrq]<='2017-10-22' 
group x by new { b.ID,b.FullName,a.type }
select new {num = x.Count(),a.type,b.FullName}

[junjian8811]

啥叫ef形式？？？

[圣殿骑士18]

百度一下这类专题不要太多。

[q107770540]

sql to linq?

[tianlang_2008]

from a in Assigneds from b in Depts where a.DeptID==b.ID && [Jbrq]>='2017-10-22' && [Jbrq]<='2017-10-22' group x by new { b.ID,b.FullName,a.type } into g select new {num = g.Count(),g.key.type,g.key.FullName}

[tianlang_2008]

另外这个是sql转linq

[SportSky666]

推荐你一款工具linqer，它可以将sql语句自动转换成linq 非常方便

[arsalois]

lambda的形式？