C# group by 分组查询

  public class Students
    {
        public string Name { get; set; }
        public char Age { get; set; }
        public decimal Money { get; set; }
    }


    protected void Page_Load(object sender, EventArgs e)
    {
        List<Students> st = new List<Students>();
        st.Add(new Students { Name = "小明", Age = '男', Money = 10 });
        st.Add(new Students { Name = "小花", Age = '女', Money = 20 });
        st.Add(new Students { Name = "阿狗", Age = '男', Money = 30 });
        st.Add(new Students { Name = "小明", Age = '男', Money = 90 });


        var query = from a in st group a by a.Name into g select new { name = g.Key,age=g.First().Age ,money = g.Sum(s => s.Money) };


        var q = st.GroupBy(a => a.Name).Select(g => new { name = g.Key, age = g.First().Age, money = g.Sum(s => s.Money) });