C# linq join返回多个结果

// 创建数据源
List<Student> students = new List<Student>()
{
    new Student { ID = 1, Name = "Alice", Age = 18 },
    new Student { ID = 2, Name = "Bob", Age = 20 },
    new Student { ID = 3, Name = "Charlie", Age = 22 }
};

List<Score> scores = new List<Score>()
{
    new Score { StudentID = 1, Subject = "Math", Grade = 90 },
    new Score { StudentID = 2, Subject = "Math", Grade = 85 },
    new Score { StudentID = 1, Subject = "English", Grade = 80 },
    new Score { StudentID = 3, Subject = "English", Grade = 95 }
};

// 执行join操作
var query = from student in students
            join score in scores on student.ID equals score.StudentID
            select new { student.Name, score.Subject, score.Grade };

// 遍历结果
foreach (var result in query)
{
    Console.WriteLine($"Student: {result.Name}, Subject: {result.Subject}, Grade: {result.Grade}");
}

Student: Alice, Subject: Math, Grade: 90
Student: Bob, Subject: Math, Grade: 85
Student: Alice, Subject: English, Grade: 80
Student: Charlie, Subject: English, Grade: 95