使用EF Core的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 OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("your_connection_string");
    }
}

using (var context = new SchoolContext())
{
    var students = context.Students
        .Where(s => s.Courses.Any(c => c.Name == "Math"))
        .ToList();

    foreach (var student in students)
    {
        Console.WriteLine(student.Name);
    }
}