A little help for nested query

[wlandgraf (Wagner Landgraf)]

For such complex queries, have you considered simply using a raw SQL expression like this:

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}'))