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 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.
