如何在Specification模式中实现实体导航属性的嵌套Include？

要实现类型安全的嵌套Include，无需依赖易出错的字符串路径，你可以修改Specification基类，改用Func<IQueryable<T>, IQueryable<T>>封装Include/ThenInclude的链式逻辑，既保留编译时类型检查，又能支持任意层级的导航属性包含。

步骤1：修改BaseSpecifications类 #

将原有的表达式集合替换为支持链式查询的委托集合：

public class BaseSpecifications<T> : ISpecifications<T> where T : class
{
    public Expression<Func<T, bool>> Criteria { get; set; }
    // 改用委托封装Include/ThenInclude的链式调用逻辑
    public List<Func<IQueryable<T>, IQueryable<T>>> Includes { get; set; } = new();

    public BaseSpecifications() { }

    public BaseSpecifications(Expression<Func<T, bool>> criteriaExpression)
    {
        Criteria = criteriaExpression;
    }

    protected virtual void AddInclude(Func<IQueryable<T>, IQueryable<T>> includeExpression)
    {
        Includes.Add(includeExpression);
    }
}

步骤2：在具体Specification中实现嵌套Include #

现在可以直接在AddInclude中编写原生的Include/ThenInclude链式调用，完全类型安全：

public class ServiceWithProvidersSpecification : BaseSpecifications<Service>
{
    public ServiceWithProvidersSpecification()
    {
        AddInclude(query => query.Include(s => s.ProviderServices)
                                 .ThenInclude(ps => ps.Provider));
    }

    public ServiceWithProvidersSpecification(string serviceId) : base(s => s.ServiceID == serviceId)
    {
        AddInclude(query => query.Include(s => s.ProviderServices)
                                 .ThenInclude(ps => ps.Provider));
    }
}

步骤3：在Repository层应用Include逻辑 #

在数据访问代码中遍历委托集合，将Include逻辑应用到查询上：

public async Task<T> GetBySpecAsync(ISpecifications<T> spec)
{
    var query = _dbContext.Set<T>().AsQueryable();

    // 应用过滤条件
    if (spec.Criteria != null)
    {
        query = query.Where(spec.Criteria);
    }

    // 执行所有Include/ThenInclude逻辑
    foreach (var includeFunc in spec.Includes)
    {
        query = includeFunc(query);
    }

    return await query.FirstOrDefaultAsync();
}

方案优势 #

• 类型安全：编译时即可检查导航属性是否存在，避免字符串路径拼写错误
• 灵活扩展：支持任意多层级的嵌套Include（比如继续追加.ThenInclude(ps => ps.ServiceRequest)）
• 语义清晰：复用EF Core原生语法，代码可读性和维护性更强

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