执行表连接后在C#中处理lambda查询结果

using System;
using System.Linq;

class Program
{
    static void Main()
    {
        // 假设有两个表，Student和Course
        var students = new[] {
            new { Id = 1, Name = "Alice" },
            new { Id = 2, Name = "Bob" },
            new { Id = 3, Name = "Charlie" }
        };

        var courses = new[] {
            new { Id = 1, Name = "Math", StudentId = 1 },
            new { Id = 2, Name = "English", StudentId = 2 },
            new { Id = 3, Name = "History", StudentId = 2 },
            new { Id = 4, Name = "Science", StudentId = 3 }
        };

        // 使用表连接将两个表关联起来
        var query = from student in students
                    join course in courses on student.Id equals course.StudentId
                    select new { student.Name, course.Name };

        // 处理查询结果
        foreach (var result in query)
        {
            Console.WriteLine($"{result.Name} is taking {result.Name}");
        }
    }
}