Create generic list from an object and its list using lambda

Question

I am trying to create a "flat" generic list of objects from an object with a list of items in it. Ill explain below:

public class Student
{
   public string Name;
   public string Age;
}

public class Classroom
{
   public string Name;
   public List<Student> Students;
}

I now have a list of Classroom objects called List<Classroom> Classrooms each populated with a list of students, all i need is a generic list that will have the following information for each classroom and every student in all classrooms:

{Classroom.Name, Student.Name, Student.Age}

Thanks in advance.

Answer 1

You could just use SelectMany Linq extension:

Classrooms.SelectMany(classroom => classroom.Students.Select(student => new 
{ 
    ClassroomName = classroom.Name, 
    StudentName = student.Name, 
    StudentAge = student.Age 
}))