Linq左连接选择集合作为属性

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

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

var query = from customer in customers
            join order in orders on customer.Id equals order.CustomerId into customerOrders
            select new
            {
                Customer = customer,
                Orders = customerOrders
            };

foreach (var result in query)
{
    Console.WriteLine($"Customer: {result.Customer.Name}");
    foreach (var order in result.Orders)
    {
        Console.WriteLine($"Order: {order.Product}");
    }
    Console.WriteLine();
}