c# - 按学校董事会和学校对教师名单进行分组

Question

我有返回教师列表的查询，我需要按学校董事会和学校对他们进行分组。

实际上是像下面这样显示数据:

School Board Name 1
School Name 1
Teacher Name 1

School Board Name 1
School Name 1
Teacher Name 2

School Board Name 1
School Name 2
Teacher Name 3

School Board Name 1
School Name 2
Teacher Name 4

我需要展示的内容:

School Board Name 1
School Name 1
Teacher Name 1
Teacher Name 2

School Board Name 1
School Name 2
Teacher Name 3
Teacher Name 4

我正在尝试使用 Linq 或 Lambda 来做这个，我不知道这是否是最好的方法。

谢谢。

Answer 1

按复合键对您的实体进行分组 - 即使用新的匿名类型按学校董事会名称和学校名称对教师进行分组:

var query = teachers.GroupBy(t => new { t.SchoolBoardName, t.SchoolName });

foreach(var schoolGroup in query)
{
   Console.WriteLine(schoolGroup.Key.SchoolBoardName);
   Console.WriteLine(schoolGroup.Key.SchoolName);

   foreach(var teacher in schoolGroup)
        Console.WriteLine(teacher.TeacherName);
}