如果过滤器参数为空，则对实体进行 linq，然后选择所有实体？

Question

我使用 ID 过滤实体，但如果 ID 为空，则我想返回所有实体。所以在下面的代码中，如果 competitorID 为 null id，则返回所有简短的竞争对手。

var competitors =
                NeptuneUnitOfWork.Briefs.FindWhere(b => b.ID == briefID)
                                 .Select(b => b.BriefCompetitors.Where(b=>b.ID == competitorID)).ToList();

Answer 1

通常你这样做:

IQueryable<Brief> briefs = NeptuneUnitOfWork.Briefs.Where(b => b.ID == briefID);

if (competitorID != null)
{
    competitors = briefs.Select(b => b.BriefCompetitors.Where(b=>b.ID == competitorID));
}
else
{
    competitors = briefs.Select(b => b.BriefCompetitors);
}

从技术上讲，您可以将问题留给 SQL Server:

// Note the || clause
competitors = briefs.Where(b => b.ID == briefID)
                    .Select(b => b.BriefCompetitors.Where(b=>b.ID == competitorID || competitorID == null));