如何使用Linq获取两个表值

using System;
using System.Linq;

class Program
{
    static void Main()
    {
        // 假设我们有两个表，一个是学生表，一个是课程表
        var students = new[]
        {
            new { Id = 1, Name = "张三" },
            new { Id = 2, Name = "李四" },
            new { Id = 3, Name = "王五" }
        };

        var courses = new[]
        {
            new { StudentId = 1, Course = "数学" },
            new { StudentId = 2, Course = "英语" },
            new { StudentId = 3, Course = "物理" }
        };

        // 使用Linq的Join操作符连接两个表，并根据学生ID进行匹配
        var query = from student in students
                    join course in courses on student.Id equals course.StudentId
                    select new { student.Name, course.Course };

        // 遍历查询结果并输出
        foreach (var result in query)
        {
            Console.WriteLine($"学生：{result.Name}，课程：{result.Course}");
        }
    }
}