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 ?
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