如何在linq select中连接列数据和返回

var customers = new List<Customer>
{
    new Customer { Id = 1, Name = "Alice" },
    new Customer { Id = 2, Name = "Bob" },
    new Customer { Id = 3, Name = "Charlie" }
};

var orders = new List<Order>
{
    new Order { Id = 1, CustomerId = 1, Product = "Product 1" },
    new Order { Id = 2, CustomerId = 2, Product = "Product 2" },
    new Order { Id = 3, CustomerId = 1, Product = "Product 3" }
};

var query = from c in customers
            join o in orders on c.Id equals o.CustomerId
            select new
            {
                CustomerName = c.Name,
                OrderProduct = o.Product
            };

foreach (var result in query)
{
    Console.WriteLine($"Customer: {result.CustomerName}, Product: {result.OrderProduct}");
}