我需要把这SQL
条语句翻译成Linq-Entity
条查询...
SELECT name, count(name) FROM people
GROUP by name
我需要把这SQL
条语句翻译成Linq-Entity
条查询...
SELECT name, count(name) FROM people
GROUP by name
Query syntax
var query = from p in context.People
group p by p.name into g
select new
{
name = g.Key,
count = g.Count()
};
Method syntax
var query = context.People
.GroupBy(p => p.name)
.Select(g => new { name = g.Key, count = g.Count() });