Question

linq 里面怎么用in比如有这个sql语句写成linq怎么写 如果以及not in怎么使用

select TOP 4*from Examine where ExamineLevel in(select LinkLevel from Link where
LinkClubId=3) and ExamineTypeId in(select LinkExamineTypeId from
Link where LinkClubId=3 )and ExamineId not in( SELECT TOP (4*0) ExamineId FROM Examine )
如果改成not in 呢

Answer 1

select TOP 4*from Examine
where ExamineLevel
not in(select LinkLevel from Link where
LinkClubId==3) --not in 把where条件改成不等于3就好啦
and ExamineTypeId
not in(select LinkExamineTypeId from Link
where LinkClubId==3 ) --not in 把where条件改成不等于3就好啦
and ExamineId not in( SELECT TOP (4*0) ExamineId FROM Examine )

追问

我问的是linq怎么写