c# - 带有 ANY 的 Entity Framework 子查询

Question

我需要帮助我正在尝试使用 Entity Framework 来执行此操作，但我不知道该怎么做。

SELECT * FROM PJT.Notifications
WHERE ProjectProgrssID = ANY(
SELECT ProjectProgressID FROM PJT.ProjectProgress
WHERE ProjectID = ANY(
SELECT ProjectID FROM PJT.Projects WHERE UniversityID = 1))

Answer 1

试试这个:

Projects.Where(p => p.UniversityId = 1)
    .SelectMany(pp => pp.ProjectProgress)
    .SelectMany(pr => pr.Notifications);