Hi, this will not work because it will select all branches of the tree. I need only 1 branch.
On Thursday, June 7, 2012 7:12:44 PM UTC+3, Alexander I. Zaytsev wrote: > > Hi, please try following code: > > > (from comments in Session.Query<CommentDto>() > where comment.CommentContainer.Id = CommentContainerID > select comment.Parent).ToList() > > > 2012/6/7 mynkow <[email protected]> > >> I have a Comment object. Each comment can have child comments. Each >> comment tree has the same CommentContainer so we can load the correct >> comment tree. I can construct the tree with the query below but I want to >> get only the parents of a specific comment. Any ideas? >> >> class Comment >> >> { >> prop Comment Parent{get;set;} >> >> >> prop CommentContainer Container{get;set;} >> >> } >> >> (from comment in Session.Query<CommentDto>() >> >> >> from parent in Session.Query<CommentDto>() >> >> >> where comment.CommentContainer.Id == CommentContainderID && comment.Parent >> == parent >> >> >> select comment) >> >> .Fetch(c => c.Parent) >> >> .ToList(); >> >> -- >> You received this message because you are subscribed to the Google Groups >> "nhusers" group. >> To view this discussion on the web visit >> https://groups.google.com/d/msg/nhusers/-/uXsZfgHSRvAJ. >> 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. >> > > -- You received this message because you are subscribed to the Google Groups "nhusers" group. To view this discussion on the web visit https://groups.google.com/d/msg/nhusers/-/aelZQZumLgwJ. 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.
