linq语句：分组统计 broup by +sum

linq语句：分组统计 broup by +sum

转载请注明出自朱朱家园http://blog.csdn.net/zhgl7688

 static void Main()
        {
            List<Score> list = new List<Score>(){
                 new  Score (){ ClassId =1, StudentId =1001, CSharp =80},
                 new  Score (){ ClassId =2, StudentId =2002, CSharp =90},
                 new  Score (){ ClassId =3, StudentId =3001, CSharp =95},
                 new  Score (){ ClassId =1, StudentId =1002, CSharp =92},
                 new  Score (){ ClassId =2, StudentId =2001, CSharp =99},
                 new  Score (){ ClassId =1, StudentId =1004, CSharp =100},
                 new  Score (){ ClassId =3, StudentId =3001, CSharp =98},
             };
            //运用Linq分班级统计CSarp成绩
            var sumList = from rb in list
                       group rb by new { rb.ClassId}   into s
                       select new
                       {
                           ClassId =s.Key.ClassId  ,
                           CSharp = s.Sum(m => m.CSharp)
                       };
            foreach (var item in sumList )
            {
                Console.WriteLine("班级：" + item.ClassId + "CSharp成绩:" + item.CSharp);
            }
            Console.Read();

转载请注明出自朱朱家园 http://blog.csdn.net/zhgl7688