分组后把字段收集到 List 中

分组后把字段收集到 List 中

static void Main(string[] args)
{
    using (var dbContext = new DataClasses1DataContext())
    {
        var q = from u in dbContext.User
                group u by u.Name into g
                select new
                {
                    name = g.Key,
                    pwds = g.Select(m => m.Password).ToList()
                };

        var list = q.ToList();
    }
}Code language: JavaScript (javascript)

结果结构：

方法语法等效写法：

var list2 = dbContext.User
               .GroupBy(m => m.Name)
               .Select(g => new
               {
                   name = g.Key,
                   pwds = g.Select(m => m.Password).ToList()
               })
               .ToList();Code language: JavaScript (javascript)

关键要点：