LINQ在执行多个连接之前选择表的列

using System;
using System.Linq;

public class Program
{
    public static void Main()
    {
        // 假设有两个表：Customers和Orders
        var customers = new[]
        {
            new { Id = 1, Name = "Alice" },
            new { Id = 2, Name = "Bob" },
            new { Id = 3, Name = "Charlie" }
        };

        var orders = new[]
        {
            new { Id = 1, CustomerId = 1, Product = "Product A" },
            new { Id = 2, CustomerId = 2, Product = "Product B" },
            new { Id = 3, CustomerId = 1, Product = "Product C" }
        };

        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}");
        }
    }
}