如何使用实体框架连接两个表并匹配外键

CREATE TABLE Courses (
    CourseID INT PRIMARY KEY,
    CourseName NVARCHAR(100)
);

CREATE TABLE Students (
    StudentID INT PRIMARY KEY,
    StudentName NVARCHAR(100),
    CourseID INT,
    FOREIGN KEY (CourseID) REFERENCES Courses(CourseID)
);

public class Course
{
    public int CourseID { get; set; }
    public string CourseName { get; set; }
    public ICollection<Student> Students { get; set; } // 导航属性
}

public class Student
{
    public int StudentID { get; set; }
    public string StudentName { get; set; }
    public int CourseID { get; set; } // 外键
    public Course Course { get; set; } // 导航属性
}

public class SchoolContext : DbContext
{
    public DbSet<Course> Courses { get; set; }
    public DbSet<Student> Students { get; set; }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("YourConnectionStringHere");
    }
}

using (var context = new SchoolContext())
{
    // 添加一个新的学生和一个新的课程
    var course = new Course { CourseName = "Mathematics" };
    var student = new Student { StudentName = "Alice", Course = course };

    context.Courses.Add(course);
    context.Students.Add(student);
    context.SaveChanges();

    // 查询所有学生及其课程
    var studentsWithCourses = context.Students.Include(s => s.Course).ToList();
    foreach (var student in studentsWithCourses)
    {
        Console.WriteLine($"Student: {student.StudentName}, Course: {student.Course.CourseName}");
    }
}