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.Companygroup c by c.Name into grpwhere grp.Count() > 1select grp.Key或者，使用方法语法：Company    .GroupBy(c => c.Name)    .Where(grp => grp.Count() > 1)    .Select(grp => grp.Key);