如何使用Linq在join中的多个表列之间求等

using System;
using System.Linq;

public class Program
{
    public static void Main()
    {
        // 创建两个数据源
        var customers = new[]
        {
            new { Id = 1, Name = "John" },
            new { Id = 2, Name = "Alice" },
            new { Id = 3, Name = "Bob" }
        };

        var orders = new[]
        {
            new { CustomerId = 1, Product = "Apple" },
            new { CustomerId = 2, Product = "Banana" },
            new { CustomerId = 3, Product = "Orange" }
        };

        // 使用Linq进行多表连接
        var query = from customer in customers
                    join order in orders on customer.Id equals order.CustomerId
                    select new { customer.Name, order.Product };

        // 输出结果
        foreach (var result in query)
        {
            Console.WriteLine($"Customer: {result.Name}, Product: {result.Product}");
        }
    }
}