从Dapper QueryMultiple中的第一个select访问结果(多对多)

using (var connection = new SqlConnection(connectionString))
{
    connection.Open();

    var sql = @"
        SELECT * FROM Students;
        SELECT * FROM Courses;
        SELECT * FROM StudentCourses;
    ";

    using (var multi = connection.QueryMultiple(sql))
    {
        var students = multi.Read<Student>().ToList();
        var courses = multi.Read<Course>().ToList();
        var studentCourses = multi.Read<StudentCourse>().ToList();

        // 处理多对多关系的结果集
        // ...

        // 示例：打印学生和他们选择的课程
        foreach (var student in students)
        {
            var selectedCourses = studentCourses
                .Where(sc => sc.StudentId == student.Id)
                .Join(courses, sc => sc.CourseId, c => c.Id, (sc, c) => c);

            Console.WriteLine($"学生 {student.Name} 选择了以下课程：");
            foreach (var course in selectedCourses)
            {
                Console.WriteLine($"- {course.Name}");
            }
        }
    }
}