Query with not in subquery

[GOMEZEL_DINO]

Hello!

How do I create a query that returns rows that do not include certain field from a subquery? For example return all invoices that do not have a certain invoice item. SQL example (meta SQL):

SELECT * 
FROM doc_headers
WHERE id NOT IN (SELECT HEADER_ID FROM doc_items WHERE PRODUCT_ID=3)

[wlandgraf (Wagner Landgraf)]

In this case you should use SQL expression:

Filtering data with two many valued associations

In this case you should use SQL expressions, using, for example, EXISTS clause. Pseudo-code: Find<TAnagrFiscale> .Where(Linq.Sql('Exists SELECT * FROM AnagrIndirizzo AI WHERE field like '%' and AI.Id = {ID}'))