asp.net DataTable,List for Linq(分组 求和 排序)

 1.Linq For DataTable

 DataTable dt = new DataTable();
            dt.Columns.Add("id", typeof(int));
            dt.Columns.Add("c", typeof(double));

            DataRow row = dt.NewRow();
            row["id"] = 1;
            row["c"] = 10.5;
            dt.Rows.Add(row);

            row = dt.NewRow();
            row["id"] = 1;
            row["c"] = 10.5;
            dt.Rows.Add(row);

            row = dt.NewRow();
            row["id"] = 2;
            row["c"] = 5.5;
            dt.Rows.Add(row);

            row = dt.NewRow();
            row["id"] = 2;
            row["c"] = 4.5;
            dt.Rows.Add(row);

            var data = from r in dt.AsEnumerable()
                       group r by r.Field<int>("id") into g
                       let sum = g.Sum(p => p.Field<double>("c"))
                       orderby sum ascending
                       select new
                       {
                           id = g.Key,
                           c = sum
                       };
                      
            foreach (var item in data)
            {
                Console.WriteLine("id:" + item.id + " c:" + item.c);
            }

 

Linq For List

List<Demo2> Demo2 = new List<Demo2> {
               new Demo2 { id = 1, name = "Demo_1" },
               new Demo2 { id = 2, name = "Demo2_2" },
               new Demo2 { id = 2, name = "Demo2_3" },
               new Demo2 { id = 4, name = "Demo2_4" },
               new Demo2 { id = 4, name = "Demo2_5" },
               new Demo2 { id = 6, name = "Demo2_6" }
           };
           var data = from q in
                          (from p in Demo2
                           where p.id > 0
                           group p by p.id into g
                           let sum = g.Sum(p => p.id)
                           let n = g.Count()
                           orderby g.Key ascending
                           select new
                           {
                               g.Key,
                               sum = sum,
                               n = n
                           })
                      where q.n >= 2
                      select q;