Entity Framework中如何动态添加ThenInclude？

EF Core中ThenInclude的泛型参数依赖于前一步Include/ThenInclude返回的属性类型，直接用键值对存储Include和ThenInclude表达式会因为泛型类型不匹配报错，以下是两种可行的实现方案：

方案一：用委托封装完整包含链（类型安全） #

直接用Func<IQueryable<TEntity>, IQueryable<TEntity>>封装每个包含链的完整逻辑，从根源避免泛型类型不匹配问题：

1. 定义扩展方法 #

public static class QueryableExtensions
{
    public static IQueryable<TEntity> ApplyIncludes<TEntity>(this IQueryable<TEntity> query, IEnumerable<Func<IQueryable<TEntity>, IQueryable<TEntity>>> includeActions)
    {
        return includeActions.Aggregate(query, (current, action) => action(current));
    }
}

2. 构建包含链 #

// 以Order实体为例：Customer关联Address，OrderItems关联Product
var includeChains = new List<Func<IQueryable<Order>, IQueryable<Order>>>
{
    q => q.Include(o => o.Customer).ThenInclude(c => c.Address),
    q => q.Include(o => o.OrderItems).ThenInclude(oi => oi.Product)
};

3. 应用到查询 #

var query = dbContext.Orders.ApplyIncludes(includeChains);

这种方案完全类型安全，写法直观，适合提前明确包含关系的场景。

方案二：用自定义类存储包含链（灵活适配动态场景） #

如果需要从外部配置（比如字符串转换为表达式）动态构建包含链，可以用自定义类存储Include和对应的ThenInclude表达式，通过动态类型处理泛型匹配：

1. 定义包含链类 #

public class IncludeChain<TEntity>
{
    public Expression<Func<TEntity, object>> IncludeExpression { get; set; }
    public List<Expression<Func<object, object>>> ThenIncludeExpressions { get; set; } = new();
}

2. 实现扩展方法处理包含链 #

public static class QueryableExtensions
{
    public static IQueryable<TEntity> ApplyIncludeChains<TEntity>(this IQueryable<TEntity> query, IEnumerable<IncludeChain<TEntity>> chains)
    {
        foreach (var chain in chains)
        {
            // 先执行Include
            var includedQuery = query.Include(chain.IncludeExpression);
            
            // 依次执行每个ThenInclude
            foreach (var thenIncludeExpr in chain.ThenIncludeExpressions)
            {
                // 通过动态类型自动匹配泛型参数
                dynamic dynamicQuery = includedQuery;
                includedQuery = dynamicQuery.ThenInclude(thenIncludeExpr);
            }
            
            query = includedQuery;
        }
        return query;
    }
}

3. 使用示例 #

var chains = new List<IncludeChain<Order>>
{
    new()
    {
        IncludeExpression = o => o.Customer,
        ThenIncludeExpressions = new() { c => ((Customer)c).Address }
    },
    new()
    {
        IncludeExpression = o => o.OrderItems,
        ThenIncludeExpressions = new() { oi => ((OrderItem)oi).Product }
    }
};

var query = dbContext.Orders.ApplyIncludeChains(chains);

这种方案灵活性更高，但依赖动态类型，类型安全性稍弱，适合需要动态生成包含关系的场景。

原代码报错原因 #

你之前的代码报错是因为IIncludableQueryable<out TEntity, out TProperty>是泛型接口，ThenInclude方法需要明确指定前一步的属性类型（TPreviousProperty）作为泛型参数，直接用非泛型的IIncludableQueryable无法自动匹配方法的泛型约束，导致编译失败。

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