Start by mapping a formula property (Total) into sales Then you can sum in projections (otherwise you have to revert to bad SqlExpression stuff)
On 18 sep, 23:00, Xminder <[email protected]> wrote: > How do I write the below with ICriteria and Projections.Sum: > > Select item_name, sum(unit_price * amount) from sales group by > item_name > > Thanks -- 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.
