实体框架无法翻译以进行过滤

Question

我在编写使用过滤器过滤产品的查询时遇到了问题。我希望能够通过productFilter过滤，但是我得到了

无法翻译。可以通过插入“可忽略的”，“ asasyncenumerable”，“ tolist”或“ tolistAsync'的呼叫来重写可以翻译的形式的查询，或者明确切换到客户端评估。

    public class ProductFilter
    {
        public DateTime? AvailableFrom { get; set; }
        public DateTime? AvailableTo { get; set; }
        public Size? Size { get; set; }
        public int? RangeFrom { get; set; }
        public int? RangeTo { get; set; }
        public List<Facet>? Facets { get; set; }
    }

    public class Facet
    {
        public Guid Id { get; set; }
        public List<FacetValue> FacetValues { get; set; } = new List<FacetValue>();
    }

    public class FacetValue
    {
        public Guid Id { get; set; }
    }

public class Product : EntityBase
{
    public virtual ICollection<ProductVariant>? Variants { get; set; }
    public virtual ICollection<FacetValue> FacetValues { get; set; } = new List<FacetValue>();
}

public class ProductVariant : EntityBase
{
    public Guid ProductId { get; set; }
    public virtual Product Product { get; set; } = null!;

    public Size Size { get; set; }
    public virtual ICollection<Order> Orders { get; set; } = new List<Order>();
    public virtual ICollection<FacetValue> FacetValues { get; set; } = new List<FacetValue>();
}

public class FacetValue : EntityBase
{
    public string Name { get; set; } = null!;

    public Guid FacetId { get; set; }
    public virtual Facet Facet { get; set; } = null!;
    
    public virtual ICollection<ProductVariant> ProductVariants { get; set; } = new List<ProductVariant>();
    public virtual ICollection<Product> Products { get; set; } = new List<Product>();
}

public class Facet : EntityBase
{
    public string Name { get; set; } = null!;
    public virtual ICollection<FacetValue> Values { get; set; } = new List<FacetValue>();
}

      return productsQuery
                        .Where(p =>
                            p.Variants != null && p.Variants!.Any(pv =>
                                !pv.Orders.Any(o =>
                                    o.StartDate <= requestFilter.AvailableTo ||
                                    o.EndDate <= requestFilter.AvailableTo
                                )
                                &&
                                (requestFilter.Size == null || pv.Size == requestFilter.Size)
                                && pv.State == ProductVariantState.Active
                                &&
                                (
                                    requestFilter.Facets.IsNullOrEmpty() ||
                                    requestFilter.Facets!.All(
                                        filterFacet =>
                                            filterFacet.FacetValues
                                                .Any(filterFacetValue =>
                                                    p.FacetValues.Any(fv => fv.Id == filterFacetValue.Id))
                                            ||
                                            filterFacet.FacetValues
                                                .Any(filterFacetValue =>
                                                    pv.FacetValues.Any(fv => fv.Id == filterFacetValue.Id))
                                    )
                                )
                            )
                        );

Answer 1

答案实际上很简单。

        if (!requestFilter.Facets.IsNullOrEmpty())
        {
            foreach (var filterFacet in requestFilter.Facets!)
            {
                productsQuery = productsQuery
                    .Where(p =>
                        p.Variants != null && p.Variants!.Any(pv =>
                            (requestFilter.Size == null || pv.Size == requestFilter.Size) &&
                            pv.State == ProductVariantState.Active &&
                            (
                                p.FacetValues.Any(
                                    pFv => filterFacet.FacetValues.Select(fv => fv.Id).Contains(pFv.Id)
                                )
                                ||
                                pv.FacetValues.Any(
                                    pvFv => filterFacet.FacetValues.Select(fv => fv.Id).Contains(pvFv.Id)
                                )
                            )
                        )
                    );
            }
        }

但是我想知道如何重构代码以使其更有用并提取以下内容：

!pv.Orders.Any(o =>
    o.StartDate <= requestFilter.AvailableTo ||
    o.EndDate <= requestFilter.AvailableTo)