c# linq goup by实例

using System;
using System.Collections.Generic;
using System.Linq;

namespace ConsoleApp3
{
    class Program
    {
        static void Main(string[] args)
        {
            List<Student> Students = GetStudents();
            //group by 一个字段
            var query1 = from a in Students
                         group a by a.SchoolID into b
                         select new
                         {
                             SchoolID = b.Key,
                             Count = b.Count()
                         };
            //group by 多个字段
            var query2 = from a in Students
                         group a by new { SchoolID = a.SchoolID, SchoolName = a.SchoolName } into b
                         select new
                         {
                             SchoolID = b.Key.SchoolID,
                             SchoolName = b.Key.SchoolName,
                             Count = b.Count()
                         };
            //group by 能获取子集合
            var query3 = Students.GroupBy(a => new { SchoolID = a.SchoolID, SchoolName = a.SchoolName });
            if (query3.Count() > 0)
            {
                foreach (var item in query3)
                {
                    int SchoolID = item.Key.SchoolID;
                    string SchoolName = item.Key.SchoolName;
                    List<Student> list = item.ToList();
                }
            }
        }
        private static List<Student> GetStudents()
        {
            List<Student> students = new List<Student>();
            students.Add(new Student(1, "student1", 1, "学校1"));
            students.Add(new Student(2, "student2", 1, "学校1"));
            students.Add(new Student(3, "student3", 2, "学校2"));
            students.Add(new Student(4, "student4", 2, "学校2"));
            students.Add(new Student(5, "student5", 3, "学校3"));
            return students;
        }
    }
    public class Student
    {
        public Student() { }
        public Student(int _studentID, string _studentName, int _schoolID, string _schoolName)
        {
            this.StudentID = _studentID;
            this.StudentName = _studentName;
            this.SchoolID = _schoolID;
            this.SchoolName = _schoolName;
        }
        public int StudentID { get; set; }
        public string StudentName { get; set; }
        public int SchoolID { get; set; }
        public string SchoolName { get; set; }
    }
}

group by多个对象

var test = from l in list
            join j in existsJobList on l.JobName equals j.Code
            join d in existsDeptList on l.DeptCode equals d.Code
            group new { l, j, d }
            by new { PositionName = l.PositionName, JobTitleId = j.JobTitleId, DeptId = d.DeptId } into b
            select new
            {
                PositionName = b.Key.PositionName,
                JobTitleId = b.Key.JobTitleId,
                DeptId = b.Key.DeptId,
            };

自定义扩展方法

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ConsoleApp10
{
    class Program
    {
        static void Main(string[] args)
        {
            //初始化学生
            List<student> students = new List<student>();
            students.Add(new student
            {
                code = "1001",
                name = "张三",
                classcode = "c001"
            });
            students.Add(new student
            {
                code = "1002",
                name = "李四",
                classcode = "c001"
            });
            students.Add(new student
            {
                code = "1003",
                name = "王五",
                classcode = "c002"
            });
            students.Add(new student
            {
                code = "1004",
                name = "马六",
                classcode = "c002"
            });

            //返回每个班级学号最小的学生
            var firstStudentInClass = (from a in students
                                       group a by a.classcode into gb
                                       let b = getFirstStudentInClass(gb)
                                       select b).ToList();
        }
        /// <summary>
        /// 获取班级学号最小的学生
        /// </summary>
        /// <param name="list"></param>
        /// <returns></returns>
        static student getFirstStudentInClass(IEnumerable<student> list)
        {
            return list.OrderBy(a => a.code).FirstOrDefault();
        }
    }
    class student
    {
        public string code { get; set; }
        public string name { get; set; }
        public string classcode { get; set; }
    }
}