probably is not support by actual implementation of Linq2NH.btw using <import> you can "map" you DTO (AccountTake).
2009/6/9 Chris Nicola <[email protected]> > I am trying this as a Linq query: > > var query = from entry in entryquery > group entry by entry.Account into list > select new AccountTake > { > Account = list.Key, > CreditAmount = list.Sum(p => p.Amount), > DebitAmount = list.Sum(p => p.Amount) > }; > > And this is the resulting SQL > > SELECT sum(this_.Amount) as y0_, > sum(this_.Amount) as y1_ > FROM Entries this_ > > Seems to be ignoring group by. Obviously this returns an exception as it > can't map that to AccountTake. > > Chris > > On Wed, Jun 3, 2009 at 3:53 PM, Fabio Maulo <[email protected]> wrote: > >> Not with anonymous type but with a real Type or a IList<object[]> >> >> 1)select e.Key, sum(e.Amount) from Entry e group by e.Key >> 2)select new YourStatisticEntry(e.Key, sum(e.Amount)) from Entry e group >> by e.Key >> 3) using 1 with a results trasformer to transform each result or the >> entirely IList. >> >> 2009/5/28 Chris Nicola <[email protected]> >> >> I was wondering if it is possible to do simple sums and groupings with >>> Linq2Nhibernate without returning the entire result set first using >>> .ToList(); >>> >>> My scenario: >>> >>> I have a table of accounts, and for each and every account I would like >>> to get a sum of transactions from three different tables. In SQL I would do >>> something like >>> >>> SELECT SUM(Amount), Account.id >>> FROM Entries >>> Group By Account.id >>> >>> In a Linq query I might try to return something like: >>> >>> from entry in session.Linq<Entry>() >>> group entry by entry.Account into list >>> select new >>> { >>> Account = list.Key, >>> Total = list.Sum(e => e.Amount) >>> }; >>> >>> However that returns an error because nHibernate is expecting to return >>> entities of type <Entry> and not the anonymous type I just defined. >>> >>> Is there any way to get results like this? >>> >>> Thanks, >>> Chris >>> >>> >>> >> >> >> -- >> Fabio Maulo >> >> >> > > > > -- Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
