EF Core中导航属性项的表达式树构建及查询适配问题

使用VS2022 + EF Core，数据上下文为_myLab05Context。存在实体Solution，包含导航属性SolutionUsages；SolutionUsages拥有StudyId属性。需要获取所有关联SolutionUsages.StudyId = 5的Solution及其对应的SolutionUsages，手动编写的查询可正常运行：

var query = await _myLab05Context.Solutions
.Select(s => new
{
    Solutions = s,
    SolutionUsages = s.SolutionUsages.Where(su => su.StudyId == 5)
})
.Where(s => s.SolutionUsages.Any(su => su.StudyId == 5))
.ToListAsync();

为实现动态切换实体、导航属性和筛选字段，编写了GenericAny和GenericWhere方法生成表达式，但替换手动查询的Where子句时，分别出现以下错误：

• ICollection无Where定义
• 类型转换失败

1. GenericAny方法问题：导航属性SolutionUsages的类型是ICollection<SolutionUsage>，直接调用Enumerable.Any无法被EF Core正确解析为SQL，且ICollection本身不实现IQueryable，需要使用Queryable.Any并先将导航属性转换为IQueryable。
2. GenericWhere方法问题：在Select子句中筛选导航属性时，需要针对IQueryable调用Queryable.Where而非Enumerable.Where，否则EF Core无法将表达式转换为数据库查询，同时方法返回值需适配导航属性的查询场景。

1. 修正GenericAny方法（用于主查询的Where条件） #

public Expression<Func<TSource, bool>> GenericAny<TSource, T2ndSource>(string navPropName, string propName, long propValue)
{
    // 生成子实体的筛选表达式：x => x.PropName == propValue
    ParameterExpression subParam = Expression.Parameter(typeof(T2ndSource), "x");
    MemberExpression subProp = Expression.Property(subParam, propName);
    ConstantExpression constant = Expression.Constant(propValue);
    BinaryExpression subBody = Expression.Equal(subProp, constant);
    var subPredicate = Expression.Lambda<Func<T2ndSource, bool>>(subBody, subParam);

    // 生成主实体的Any表达式：s => s.NavProp.AsQueryable().Any(subPredicate)
    ParameterExpression mainParam = Expression.Parameter(typeof(TSource), "s");
    MemberExpression navProp = Expression.Property(mainParam, navPropName);
    // 将ICollection转换为IQueryable
    MethodCallExpression asQueryableCall = Expression.Call(
        typeof(Queryable), nameof(Queryable.AsQueryable), 
        new[] { typeof(T2ndSource) }, navProp);
    // 调用Queryable.Any
    MethodCallExpression anyCall = Expression.Call(
        typeof(Queryable), nameof(Queryable.Any), 
        new[] { typeof(T2ndSource) }, asQueryableCall, subPredicate);

    return Expression.Lambda<Func<TSource, bool>>(anyCall, mainParam);
}

2. 修正GenericWhere方法（用于Select子句中筛选导航属性） #

该方法生成针对导航属性的筛选表达式，适配IQueryable调用：

public Expression<Func<TSource, IEnumerable<T2ndSource>>> GenericWhereForNavProp<TSource, T2ndSource>(string navPropName, string propName, long propValue)
{
    // 生成子实体的筛选表达式：x => x.PropName == propValue
    ParameterExpression subParam = Expression.Parameter(typeof(T2ndSource), "x");
    MemberExpression subProp = Expression.Property(subParam, propName);
    ConstantExpression constant = Expression.Constant(propValue);
    BinaryExpression subBody = Expression.Equal(subProp, constant);
    var subPredicate = Expression.Lambda<Func<T2ndSource, bool>>(subBody, subParam);

    // 生成主实体的导航属性筛选表达式：s => s.NavProp.AsQueryable().Where(subPredicate)
    ParameterExpression mainParam = Expression.Parameter(typeof(TSource), "s");
    MemberExpression navProp = Expression.Property(mainParam, navPropName);
    // 将ICollection转换为IQueryable
    MethodCallExpression asQueryableCall = Expression.Call(
        typeof(Queryable), nameof(Queryable.AsQueryable), 
        new[] { typeof(T2ndSource) }, navProp);
    // 调用Queryable.Where
    MethodCallExpression whereCall = Expression.Call(
        typeof(Queryable), nameof(Queryable.Where), 
        new[] { typeof(T2ndSource) }, asQueryableCall, subPredicate);

    return Expression.Lambda<Func<TSource, IEnumerable<T2ndSource>>>(whereCall, mainParam);
}

将修正后的方法替换手动查询，实现动态查询：

// 生成Any条件表达式：筛选关联SolutionUsages.StudyId=5的Solution
var anyExpr = GenericAny<Solution, SolutionUsage>(nameof(Solution.SolutionUsages), nameof(SolutionUsage.StudyId), 5);
// 生成导航属性筛选表达式：只返回Solution中StudyId=5的SolutionUsages
var whereNavExpr = GenericWhereForNavProp<Solution, SolutionUsage>(nameof(Solution.SolutionUsages), nameof(SolutionUsage.StudyId), 5);

// 构建动态查询
var query = _myLab05Context.Solutions
    .Select(s => new
    {
        Solutions = s,
        SolutionUsages = whereNavExpr.Compile()(s)
    })
    .Where(anyExpr);

var result = await query.ToListAsync();

可选：完全基于表达式树的Select构建（避免Compile） #

如果希望全程用表达式树构建Select，可添加以下辅助方法：

public Expression<Func<TSource, dynamic>> BuildDynamicSelect<TSource, T2ndSource>(Expression<Func<TSource, IEnumerable<T2ndSource>>> navPropFilterExpr)
{
    ParameterExpression param = Expression.Parameter(typeof(TSource), "s");
    // 主实体引用
    MemberExpression mainEntity = param;
    // 导航属性筛选结果（替换参数为当前param）
    var filteredNavProp = Expression.Invoke(navPropFilterExpr, param);
    // 构建匿名类型初始化
    var anonymousType = new { Solutions = default(TSource), SolutionUsages = default(IEnumerable<T2ndSource>) }.GetType();
    var bindings = new MemberBinding[]
    {
        Expression.Bind(anonymousType.GetProperty(nameof(Solution)), mainEntity),
        Expression.Bind(anonymousType.GetProperty(nameof(Solution.SolutionUsages)), filteredNavProp)
    };
    var initExpr = Expression.MemberInit(Expression.New(anonymousType), bindings);

    return Expression.Lambda<Func<TSource, dynamic>>(initExpr, param);
}

使用时直接传入表达式：

var selectExpr = BuildDynamicSelect<Solution, SolutionUsage>(whereNavExpr);
var query = _myLab05Context.Solutions
    .Select(selectExpr)
    .Where(anyExpr);

• Queryable优先：EF Core查询必须使用Queryable系列方法（如Queryable.Any、Queryable.Where），才能将表达式转换为SQL；Enumerable方法会在客户端内存过滤，无法利用数据库索引，还可能引发类型错误。
• 导航属性转换：对于ICollection<T>类型的导航属性，必须通过AsQueryable()转换为IQueryable<T>，才能调用Queryable方法。
• 参数一致性：组合表达式时，确保子表达式的参数与主表达式参数一致，避免参数不匹配导致的类型转换错误。

内容的提问来源于stack exchange，提问作者Hucky