c# - 如何将谓词与 Included 属性一起包含？

Question

目前我有一个函数允许我查询数据库，同时在结果中包含一些其他相关表，以防止返回命中数据库，否则我知道如果不这样做会发生:

public class EntityRepository<TEntity> : IEntityRepository<TEntity> where TEntity : class
{
    protected DbSet<TEntity> dbSet;

    private readonly DbContext dc;

    public EntityRepository()
    {
        dc = new DbContext(Utility.Config.GetEntityDbConnection());
        dbSet = dc.Set<TEntity>();
    }


    public IQueryable<TEntity> GetAllIncluding(params Expression<Func<TEntity, object>>[] includeProperties)
    {
            foreach (var includedProperty in includeProperties)
            {
                dbSet.Include(includedProperty).Load();
            }

            return dbSet;
    }
}

但是，我还需要能够在包含之前使用一个 where 子句，以便它在触发 Load() 方法时不会尝试查询整个数据库。

我正在尝试做这样的事情(这显然行不通，因为您可以像下面的示例代码一样重新分配 dbset)。

    public IQueryable<TEntity> SearchForIncluding(Expression<Func<TEntity, bool>> predicate, params Expression<Func<TEntity, object>>[] includeProperties)
    {
           dbset = dbSet.Where(predicate);  //THIS DOESN'T WORK OBVIOUSLY

           foreach (var includedProperty in includeProperties)
           {
                dbSet.Include(includedProperty).Load();
           }
    }

Answer 1

您应该能够在 Include 和 Load 之间对 Where 的调用中应用谓词，如下所示:

foreach (var includedProperty in includeProperties)
{
     dbSet.Include(includedProperty).Where(predicate).Load();
}