I've hit the same issue - did you find a solution? If you find a way while still using LINQ (rather than having to bring in direct NH dependencies on HQL/QueryOver) please do post back here!
Not sure if there's a JIRA bug for this stuff, but would seem like a common requirement? Thanks! James On 6 January 2011 13:02, Variant <[email protected]> wrote: > I am trying to perform a group by Linq query with NH3. Knowing the > underling SQL difficulties I know it's not possible but Ideally I > would like to do the group by an entity and have it retrieved in it's > entirety. Something like: > > var list = from proposals in Session.Query<Proposal>() > group proposals by proposals.Job > into jobGrouping > select new { > Job = jobGrouping.Key, > TotalProposals = jobGrouping.Count() > }; > This generates an illegal SQL query as it tries to retrieve the whole > Job entity but group only by its Id. > > I have tried grouping by a composite field: > > var list = from proposals in Session.Query<Proposal>() > group proposals by new { proposals.Job.Name, > proposals.Job.Status} > into jobGrouping > select new { > Job = jobGrouping.Key.Name, > Status = jobGrouping.Key.Status, > TotalProposals = jobGrouping.Count() > }; > But whenever I try this I get an Exception when NHibernate tryes to > build an expression tree: > > An item with the same key has already been added. > > Anyone knows if there is any way to accomplish that with NHibernate ? > > Thanks, Ilan > > -- > 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]<nhusers%[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.
