That was a good article and it showed the CTE approach to hierarchical queries. If you use MSSQL and don't need to add any extra criteria (without complicating the SQL query), it is a good approach.
The question is, what do you want to accomplish? Deep queries or only two levels? /G 2011/1/18 Eric <[email protected]> > I know that my initial example does work past one level. > I don't know what the underlying SQL looks like. > > See this link: > > http://blogs.hibernatingrhinos.com/nhibernate/archive/2008/05/14/how-to-map-a-tree-in-nhibernate.aspx > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
