Hello,

I have a one-to-many relationship. And now that I look at nHibernate queries, it looks like nHibernate is firing a query per child object.

Is there a way I can instruct nHibernate to fire one query that loads all the child information from the db.

So for example instead of:
select _child.propA, _child.propB from Child _child where _childId = 0;
select _child.propA, _child.propB from Child _child where _childId = 1;
select _child.propA, _child.propB from Child _child where _childId = 2;

it would execute:
select _child.propA, _child.propB from Child _child where _childId in (0, 1, 2);

and then populate the child objects with that set?

Thanks

It is possible using either join fetching or sub-select fetching. When does each one got invoked depends on a number of things. The documentation on fetching strategy has all the detail information:
http://www.hibernate.org/hib_docs/nhibe ... e-fetching