I would probably just pull all of the relavant sales objects with NH and then use some old fashioned foreach loops and linq to transform to your dto. You still pull all of your data in one query, and unless you're talking about 10k+ rows, c# is plenty fast for that data manipulation.
On Feb 25, 2009 4:40 AM, "Andyk" <[email protected]> wrote: Hi, Im looking for some advise on how to go about presenting some report data. In my scenario, I have the following Sales object: SalesId Customer SalesType Amount I want to be able to produce a report, a row for each customer, with the different salesTypes as columns, and Amount values in the middle. Effectively its pivoting the data. So I thought that I needed to look at creating a new custom domain object, ReportDTO, which might look something like: Customer DepositType CommissionType BonusType But Im stumped as how to write the criteria api, to transform the data. Effectively I need a query for each SalesType, is this correct? And I need to group it by CustomerId. But Im thinking I need to manually collect each data, for each customer, populate my own Report object, and add it to a list. Which is going to be alot slower. Can I get Nhibernate to do this in some way? Any advise gratefully appreciated. Andy --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
