如何在Linq中编写带有案例的左连接(C# MVC)

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 = 2, Product = "Tablet" },
    new Order { Id = 4, CustomerId = 3, Product = "Headphones" }
};

var query = from customer in customers
            join order in orders on customer.Id equals order.CustomerId into customerOrders
            from customerOrder in customerOrders.DefaultIfEmpty()
            select new
            {
                CustomerName = customer.Name,
                OrderProduct = customerOrder?.Product ?? "No Order"
            };

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