这个LinQ咋写

[zdz8712]

如题，现有 List<Model> myList;
Model 有ID,Name 两个字段
我要得出myList中按照 Model.Name分组的记录 和 相应的记录条数，该咋写呢

[我姓区不姓区]

var query = from model in myList
                group model by model.Name;
foreach(var group in query)
     Console.WriteLine("Name:{0},Count:{1}",group.Key,group.Count());

[小D2013]

var r= from a in myList
group a by new {a.Name} into g

select new
{
g.Key.Name,
记录数= g.Sum(p => p.结账金额-p.找零金额)
};

[vrhero]

不用那么麻烦...一句...

list.GroupBy(m => m.Name).Select(g => new { Name = g.Key, Count = g.Count() })

[机器人]

var list = new List<Model> 
{ 
    new Model{ Name="1"},
    new Model{ Name="3"},
    new Model{ Name="1"},
    new Model{ Name="2"},
    new Model{ Name="2"},
    new Model{ Name="1"},
};
var query = from m in list
            group m by m.Name into g
            select g;

foreach (var x in query)
    foreach (var y in x)
        Console.WriteLine(y.Name + ":" + x.Count());

[claymore1114]

 var query = myList.GroupBy(g => g.Name)
                   .Select(s => new { 
                                      key = s.Key, 
                                      count = s.Count(),
                                      items = s 
                                    });

[zdz8712]

问题已经解决，多谢各位，结贴散分

[wm_qdu]

                        var query = from r in list
                        group r by r.Name into g
                        select new { Name = g.Key, Count = g.Count() };

给点分吧，我好穷~