I am trying to write linq lambda exp and IDK how to convert this from sql

SELECT * FROM Students s
WHERE s.MathGrades > 5 
AND s.FizGrades > 5 
AND NOT (s.MathGrades =2 AND s.FizGrades = 2) 

How to write "AND NOT" in linq Lambda exp ?

CodePudding user response：

The same way you would write it in C# code generally. AND NOT is && !

The full LINQ query:

from s in students
where s.MathGrades > 5 && s.FizGrades > 5 && !(s.MathGrades == 2 && s.FizGrades == 2)
select s