entity-framework - 如何将sql查询转换为实体框架核心

Question

我想将 sql 查询转换为实体框架核心。SQL查询是

select * from Departments where id in(select DepartmentId from SubDepartments where id in(select SubDeptId from Tests where id in(select TestId from PatientTests where PatientId=3)))

标签： entity-frameworkentity-framework-6entity-framework-core

Answer 1

假设实现了导航属性，并且没有任何示例代码，这是对如何实现它的最佳估计。

context.Departments.Where(x => x.SubDepartment.Test.PatientTest.PatientId == 3);