有没有办法在Entity Framework中使用来自不同实体的多个过滤参数？

// 假设我们有两个实体：Order 和 Customer
public class Order
{
    public int OrderId { get; set; }
    public DateTime OrderDate { get; set; }
    public int CustomerId { get; set; }
    // 其他属性...
}

public class Customer
{
    public int CustomerId { get; set; }
    public string Name { get; set; }
    // 其他属性...
}

// 获取符合多个过滤条件的订单
public List<Order> GetFilteredOrders(string customerName, DateTime startDate, DateTime endDate)
{
    using (var context = new YourDbContext())
    {
        var filteredOrders = context.Orders
            .Where(o => o.OrderDate >= startDate && o.OrderDate <= endDate)
            .Join(context.Customers,
                order => order.CustomerId,
                customer => customer.CustomerId,
                (order, customer) => new { Order = order, Customer = customer })
            .Where(o => o.Customer.Name == customerName)
            .Select(o => o.Order)
            .ToList();
        
        return filteredOrders;
    }
}