Hi, actually it is impossible to do this grouping and transformation to an Array or List property in SQL. So if such a feature should be implemented (surely that's possible) it must be something in memory. I'm not familiar with the NHibernate code base but maybe such a result could be achieved similarly to the way FetchMany works. With a join fetch and then some transformation on the result. But as the discussion goes in some other thread, it has some problems, too (returning the queried result with duplicates as often as the result count in the child result set).
On 1 Jun., 00:55, Mohamed Meligy <[email protected]> wrote: > Thanks Fabio :) > > @CSharper > > I think the correct behavior here would be the JOINs (Repeating parent Car > columns from the example) similar to the way fetch works but only for the > properties/column in the child Wheel select, then some transformation to do > the grouping in memory (not sure about this one whether it'd be in memory or > SQL). > > I can see it's likely not an easy one to have hooks that can identify this > situation to change the behavior to JOINs though. > > *Mohamed Meligy > *Readify | Senior Developer > > M:+61 451 835006 | W: readify.net > [image: Description: Description: Description: Description: > rss_16]<http://gurustop.net> > [image: Description: Description: Description: Description: > cid:[email protected]] > <http://www.linkedin.com/in/meligy> [image: > Description: Description: Description: Description: > cid:[email protected]] <http://twitter.com/meligy> > <http://www.greatplacetowork.com.au/best/best-companies-australia.php><http://www.readify.net/AboutUs/NewsItem.aspx?id=10> > > > > On Wed, Jun 1, 2011 at 7:37 AM, Fabio Maulo <[email protected]> wrote: > > Mohamed, > > thanks to analyze the problem so deeper before realize that it is something > > to file a JIRA. > > > -- > > 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. -- 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.
