Group a teacher list by School Board and School

Question

I have query that return a list of Teachers and I need to group them by School Board and School.

Actually a show the data like bellow:

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

What I need to show:

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

I'm trying using Linq or Lambda to make this, I don't know if this is the best way.

Thanks.

Take a look at [this](http://stackoverflow.com/questions/5231845/c-sharp-linq-group-by-on-multiple-columns), for example. — Andrei V, Dec 02 '13 at 11:23

score 5 · Accepted Answer · answered Dec 02 '13 at 11:25

Group your entities by composite key - i.e. use new anonymous type to group teachers by school board name and school name:

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);
}

Group a teacher list by School Board and School

1 Answers1