Linq与组通过计数

Question

如何在linq（vb.net）中编写此查询？ select B.Name from Company B group by B.Name having COUNT(1) > 1

Answer 1

像这样：

from c in db.Company

group c by c.Name into grp

where grp.Count() > 1

select grp.Key

或者，使用方法语法：

Company

    .GroupBy(c => c.Name)

    .Where(grp => grp.Count() > 1)

    .Select(grp => grp.Key);