Does this help? http://blogs.hibernatingrhinos.com/nhibernate/archive/2008/05/14/how-to-map-a-tree-in-nhibernate.aspx
Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Wed, Jul 1, 2009 at 6:57 PM, Graham Bunce <grahambu...@hotmail.com>wrote: > > All, > > I'm trying to create the HQL to load an entity and all its children, > ordering both and I'm struggling a little. It may be possible using > Critera but I must admit I find those a little hard to understand so > tend to use HQL. > > I have a self referencing table with data like the following > > ID,Name,Parent,Sequence > 1, Fred, null, 0 > 2, Jack, 1, 0 > 3, Jill, 1, 1 > 4, Mary, 1, 2 > 6, Bill, null, 1 > 7, Murray, 6, 0 > 8, Katy, 6, 1 > 9, New York, 8, 0 > 10, London, 8, 1 > 11, Boston, 8, 2 > > > So Fred and Bill are both roots but are sorted in sequence (0,1). They > each have their own children also sorted in sequence. As you can see, > the Sequence numbers are sequential within their level parent. Its > possible (i.e. Katy) for the hierarchy to continue down. In my case > though I am only ever going to have a maximum 3 levels (root -> child - > > child). > > What I'm after is HQL or the criteria query that lets me load a root > for an id, all the children (children A) for that root sorting those > children A by Sequence, then all the children (children B) of children > A sorting those Children B by sequence. > > I tried HQL similar to LEFT JOIN FETCH but it loads duplicate roots > and I don't think I could sort Children B with this method. > > Any advice please - thanks. > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to nhusers@googlegroups.com To unsubscribe from this group, send email to nhusers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---