Select Where in LINQ

Question

How to convert code select below in LINQ?

select * from producao
where id not in
(select idProducao from bpi)

Answer 1

You can do it like this:

db.Producao.Where(p => !db.Bpi.Select(b => b.idProducao).Contains(c.Id));

I put in the Github for future reference.

Answer 2

producao.Where(p=>!bpi.Select(p=>p.idProducao).ToList().Contains(id))