c# - 实体查询中的 If Else 语句

Question

我试图在实体查询中生成一个 if else 语句，我有以下代码:

var asset = dbContext.Set<Asset>()
    .Include(x => x.Item)
    .Include(x => x.Item.ItemDetailSubCategory)
    .Include(x => x.AssetCurrentStatus)
    .Include(x => x.AssetCurrentStatus.AssetCondition)
    .Include(x => x.Currency)
    .Include(x => x.AssetCurrentStatus.AssetAccessories)
    .Where(x => x.AssetCurrentStatus.Room.Floor.IsActive == true)
    .Where(x => x.AssetCurrentStatus.Room.Floor.Building.IsActive == true)
    .Where(x => x.AssetCurrentStatus.Room.IsActive == true)
    .ToList();

现在我希望是这样的:

var asset = dbContext.Set<Asset>()
    .Include(x => x.Item)
    .Include(x => x.Item.ItemDetailSubCategory)
    .Include(x => x.AssetCurrentStatus)
    .Include(x => x.AssetCurrentStatus.AssetCondition)
    .Include(x => x.Currency)
    .Include(x => x.AssetCurrentStatus.AssetAccessories)

if(x.AssetCurrentStatus.AssetLocation != null)
{
    .Where(x => x.AssetCurrentStatus.Room.Floor.IsActive == true)
    .Where(x => x.AssetCurrentStatus.Room.Floor.Building.IsActive == true)
    .Where(x => x.AssetCurrentStatus.Room.IsActive == true)
}
else
{
    .ToList()
}

有什么办法可以实现吗？提前致谢

Answer 1

好吧，if 没有意义，因为您希望在每个 Assets 上不仅应用该逻辑一次。所以你需要将它应用到查询本身:

var asset = dbContext.Set<Asset>()
    .Include(....)
    .Where(x => x.AssetCurrentStatus.AssetLocation == null 
            || (x.AssetCurrentStatus.Room.Floor.IsActive 
             && x.AssetCurrentStatus.Room.Floor.Building.IsActive 
             && x.AssetCurrentStatus.Room.IsActive))
    .ToList();

连续的&&与连续的Where相同