我需要翻译这个SQL
声明给一个Linq-Entity
询问...
SELECT name, count(name) FROM people
GROUP by name
查询语法
var query = from p in context.People
group p by p.name into g
select new
{
name = g.Key,
count = g.Count()
};
方法语法
var query = context.People
.GroupBy(p => p.name)
.Select(g => new { name = g.Key, count = g.Count() });
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)