从ASP.NET核心的两个表中检索数据

public class Student
{
    public int Id { get; set; }
    public string Name { get; set; }
    public List<Course> Courses { get; set; } = new List<Course>();
}

public class Course
{
    public int Id { get; set; }
    public string Title { get; set; }
    public int StudentId { get; set; }
    public Student Student { 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("YourConnectionStringHere");
    }
}

using (var context = new SchoolContext())
{
    // 使用LINQ查询两个表的数据
    var studentsWithCourses = context.Students
        .Include(s => s.Courses) // 预加载关联的课程
        .ToList();

    foreach (var student in studentsWithCourses)
    {
        Console.WriteLine($"Student: {student.Name}");
        foreach (var course in student.Courses)
        {
            Console.WriteLine($"  Course: {course.Title}");
        }
    }
}