outer-join-fetching

Should you use outer join fetching with NHibernate and Sql Server 2008?

On outer join fetching, the Nhibernate documentation says: If your database supports ANSI or Oracle style outer joins, outer join fetching might increase performance by limiting the number of round trips to and from the database (at the cost of possibly more work performed by the database itself). Outer join fetching al...

HQL: Fetch Join Collections from Eager Table

I have four tables: RootNode // Will return multiple root nodes SubNode // Will return one sub node per root node SubNodeChildren1 // Will return multiple for each sub node SubNodeChildren2 // Will return multiple for each sub node and a similar entity structure: RootNode -> SubNode -> SubNodeChildren1 -> SubNode...