单次输出多表的Linq查询

using System;
using System.Linq;

public class Program
{
    public static void Main(string[] args)
    {
        // 假设我们有两个表：Students 和 Courses
        var students = new[]
        {
            new { Id = 1, Name = "Alice" },
            new { Id = 2, Name = "Bob" },
            new { Id = 3, Name = "Charlie" }
        };

        var courses = new[]
        {
            new { Id = 1, CourseName = "Math" },
            new { Id = 2, CourseName = "Science" },
            new { Id = 3, CourseName = "History" }
        };

        // 使用Join操作符连接两个表，并选择投影到新的匿名类型中
        var query = from student in students
                    join course in courses on student.Id equals course.Id
                    select new { student.Name, course.CourseName };

        // 遍历结果并输出
        foreach (var result in query)
        {
            Console.WriteLine($"Student: {result.Name}, Course: {result.CourseName}");
        }
    }
}