I have partially sorted out the problem. Using this HQL I can recursively fetch the first two levels of the tree.
from Session.Query<Folder>() f left join fetch f.Child c where f.Name like :nameparam or c.Name like :nameparam How I can infinite recurse this table using the same approach? Here the DB admin suggests me a Common Table Expression, can I do it with HQL? -- 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.
