Filtering data with two many valued associations

[wlandgraf (Wagner Landgraf)]

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