Feeling guilty to ask this, but I've got an object A with a collection of children B..

Given that I select object A with a query, I get the object returned and all of its children.. great..

But given that I want to select a collection of A where it has at least one child that meets my conditions, and not only that, but the children in A must be exactly those that met those conditions..

..in a single query.. does that make sense?

I very much appreciate any help on this, I'll be working on this myself so I'll post my results for the sake of anyone else starting out wanting to do such a query.

I don't think you can do that directly.

You can do the initial query to get the A objects with criteria on B and then you can use ISession.CreateFilter() to filter the child collection of B objects to to get a list of child objects that only match the filter criteria.

There may be another way, but I'm not aware of it.

Cheers,

Symon.