LINQ -搜索一对多以精确匹配数组

// 学生类
public class Student
{
    public int StudentID { get; set; }
    public string Name { get; set; }
}

// 课程类
public class Course
{
    public int CourseID { get; set; }
    public string Name { get; set; }
    public int StudentID { get; set; }
}

// 创建学生数组
var students = new List<Student>
{
    new Student { StudentID = 1, Name = "张三" },
    new Student { StudentID = 2, Name = "李四" },
    new Student { StudentID = 3, Name = "王五" }
};

// 创建课程数组
var courses = new List<Course>
{
    new Course { CourseID = 1, Name = "数学", StudentID = 1 },
    new Course { CourseID = 2, Name = "英语", StudentID = 1 },
    new Course { CourseID = 3, Name = "物理", StudentID = 2 },
    new Course { CourseID = 4, Name = "化学", StudentID = 3 },
    new Course { CourseID = 5, Name = "历史", StudentID = 3 }
};

// 使用LINQ查询表达式进行一对多的精确匹配搜索
var query = from student in students
            join course in courses on student.StudentID equals course.StudentID into studentCourses
            select new { Student = student, Courses = studentCourses };

// 输出结果
foreach (var result in query)
{
    Console.WriteLine($"学生：{result.Student.Name}");
    Console.WriteLine("课程：");
    foreach (var course in result.Courses)
    {
        Console.WriteLine($"- {course.Name}");
    }
    Console.WriteLine();
}