このSQL
文をLinq-Entity
クエリに変換する必要があります...
SELECT name, count(name) FROM people
GROUP by name
ベストアンサー1
クエリ構文
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() });