多对多关系EF 6 (4个表和1个多对多关系)如何使用linq进行选择

// 创建实体类
public class Student
{
    public int StudentId { get; set; }
    public string Name { get; set; }
    public ICollection<Course> Courses { get; set; }
}

public class Course
{
    public int CourseId { get; set; }
    public string Name { get; set; }
    public ICollection<Student> Students { get; set; }
}

// 创建上下文类
public class SchoolContext : DbContext
{
    public DbSet<Student> Students { get; set; }
    public DbSet<Course> Courses { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Student>()
            .HasMany(s => s.Courses)
            .WithMany(c => c.Students)
            .Map(cs =>
            {
                cs.MapLeftKey("StudentId");
                cs.MapRightKey("CourseId");
                cs.ToTable("StudentCourse");
            });
    }
}

// 使用LINQ进行选择
using (var context = new SchoolContext())
{
    var studentsWithCourses = context.Students
        .Where(s => s.Name.Contains("John"))
        .Select(s => new
        {
            StudentName = s.Name,
            Courses = s.Courses.Select(c => c.Name)
        })
        .ToList();

    foreach (var student in studentsWithCourses)
    {
        Console.WriteLine("Student: " + student.StudentName);
        Console.WriteLine("Courses: " + string.Join(", ", student.Courses));
        Console.WriteLine();
    }
}