linq-to-sql - Linq 2 SQL 分组问题

Question

var groups = from p in dc.Pool
             join pm in dc.PoolMembers on p.ID equals pm.PoolID
             group p by p.Group into grp
             select new { grp.ID };

这不起作用。基本上我想进行分组，然后选择某些列，但是当我这样做时 select new { grp. } 我没有得到智能感知，所以我显然做错了什么。

有什么想法吗？

Answer 1

我不确定，但是以下代码是否有效？

var groups = from p in dc.Pool
             join pm in dc.PoolMembers on p.ID equals pm.PoolID
             group p by p.Group into grp
             select grp.Select(g=> g.ID);

编辑

var groups = from p in dc.Pool
             join pm in dc.PoolMembers on p.ID equals pm.PoolID
             group p by p.Group into grp
             select grp.Select(g=> new{ 
                  Id = g.Id, 
                  GroupName = grp.Key.Name,
                  Contribution = pm.Contribution,
                  GameName = p.GameName, });