Hi, one more question, this time I'd like to know more about the possibility for aggregating query results.
In my SL-LOB-Application, I'd like to query my database for some aggregate values. Eg: I'd like to have the following values out of my "AccountTransactions"-Table: The count of (all or a queried amount of) entities stored, the sum of (all or a queried amount of) payments, the avg of (all or a queried amount of) payments.... The entities should not be loaded to the client, the query should be executed server-side, only the result (or a created result-entity) should be submitted.
Hopefully this might be simple. Is there a "best practice" to achieve that?
Thanks for any help in advance! Roland