需要将左连接SQL转换为linq查询-感谢帮助

public class Order
{
    public int OrderId { get; set; }
    public string OrderName { get; set; }
    public int CustomerId { get; set; }
}

public class Customer
{
    public int CustomerId { get; set; }
    public string CustomerName { get; set; }
}

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

var customers = new List<Customer>
{
    new Customer { CustomerId = 1, CustomerName = "Customer 1" },
    new Customer { CustomerId = 2, CustomerName = "Customer 2" }
};

var query = from order in orders
            join customer in customers on order.CustomerId equals customer.CustomerId into gj
            from subCustomer in gj.DefaultIfEmpty()
            select new
            {
                OrderId = order.OrderId,
                OrderName = order.OrderName,
                CustomerName = subCustomer?.CustomerName
            };