多对多关系表到实体MVC的查询

CREATE TABLE Student (
    StudentID INT PRIMARY KEY,
    Name VARCHAR(100)
);

CREATE TABLE Course (
    CourseID INT PRIMARY KEY,
    Title VARCHAR(100)
);

CREATE TABLE StudentCourse (
    StudentID INT,
    CourseID INT,
    PRIMARY KEY (StudentID, CourseID),
    FOREIGN KEY (StudentID) REFERENCES Student(StudentID),
    FOREIGN KEY (CourseID) REFERENCES Course(CourseID)
);

public class Student
{
    public int StudentID { get; set; }
    public string Name { get; set; }
    public List<Course> Courses { get; set; }
}

public class Course
{
    public int CourseID { get; set; }
    public string Title { get; set; }
    public List<Student> Students { get; set; }
}

public class StudentController : Controller
{
    private readonly ApplicationDbContext _context;

    public StudentController(ApplicationDbContext context)
    {
        _context = context;
    }

    public async Task<IActionResult> Details(int? id)
    {
        if (id == null)
        {
            return NotFound();
        }

        var student = await _context.Students
            .Include(s => s.Courses)
            .FirstOrDefaultAsync(m => m.StudentID == id);

        if (student == null)
        {
            return NotFound();
        }

        return View(student);
    }
}

@model Student

<h2>@Model.Name's Courses</h2>
<ul>
    @foreach (var course in Model.Courses)
    {
        <li>@course.Title</li>
    }
</ul>