I modeled all of my tables and already ported most of my queries using detached criteria's. All is working very well however I'm at a point where I don't know how to advance. I have a sub-query that uses Oracle's "connect by" clause. How do developers typically overcome that limitation of Castle/NHibernate?
I am using the latest version of NHibernate.
If you really need to use connect by, you can always use a SQL Query (and there's a whole chapter about it).
However, given NHibernate's usage of the Identity Map pattern, is usually more productive to just load the objects and let the relationships be established in memory.