LINQ 分组依据表达式语法

我有一个与此类似的 T-SQL 查询：

SELECT r_id, r_name, count(*)
FROM RoomBindings
GROUP BY r_id, r_name

我想使用 LINQ 做同样的事情。到目前为止我到达这里：

var rooms = from roomBinding in DALManager.Context.RoomBindings
                        group roomBinding by roomBinding.R_ID into g
                        select new { ID = g.Key };

如何提取 count(*) 和 r_name 部分？

尝试这个：

var rooms = from roomBinding in DALManager.Context.RoomBindings
                        group roomBinding by new 
                        { 
                           Id = roomBinding.R_ID, 
                           Name = roomBinding.r_name
                        }
                        into g
                        select new 
                        { 
                           Id = g.Key.Id,
                           Name = g.Key.Name,
                           Count = g.Count()  
                        };

Nick 编辑 - 添加方法链语法以进行比较

var rooms = roomBinding.GroupBy(g => new { Id = g.R_ID, Name = g.r_name })
                       .Select(g => new
                           {
                               Id = g.Key.Id,
                               Name = g.Key.Name,
                               Count = g.Count()
                           });