Target:
Load Parent with Children filtering by Child column(s).

Problem:
NHibernate creates join for Children, i.e. select * from Parent p left join Children c on p.ParentId = c.ParentId where c.Name like 'John%', so if Parent has one than more Child, duplicate Parent records will be loaded.

Is there any way to do this..?

Regards,
Mindaugas

Use an 'in':



Additions can be made for eagerly loading children. This can also be done with Criteria.