How to use "Not Exists" in LINQ?

Question

How to use "Not Exists" in LINQ?

Navigation

#1 by (2 votes)

3

I'm trying to translate the query below into LINQ, but without success, can anyone help me?

SELECT * FROM PESSOAL A 
WHERE NOT EXISTS (
    SELECT Chapa FROM PRODUCAO B 
    WHERE B.Chapa = A.Chapa AND B.Data='2014-09-02') 
AND A.Codsubord='CB02010100';

sql c# linq query

asked by anonymous 10.09.2014 / 16:22

1 answer

How can I not serialize some attributes in RESTful (C # + WCF + JSON) calls? What is the Journal file for Android

score 2 · Accepted Answer

Try:

db.Pessoal.where(a => !db.Producao.Any(b => b.Chapa == a.Chapa && b.Data == new DateTime(2014, 09, 02)) && a.Codsubord== "CB02010100");

So, I'm going to get all data from the Pessoa ( SELECT * FROM PESSOAL ) table, where the Producao data you want is not available. Stop such use !db.Producao.Any(...) to make NOT EXISTS