Aggregate Functions

Posts   
 
    
Mennisujay
User
Posts: 11
Joined: 25-Feb-2005
# Posted on: 28-Apr-2005 12:48:27   

hi Otis,

Can i create aggregate functions on EntityCollection. If not is there any way that we can solve this thing. And also, how can we get the functionality of 'Distinct' keyword of Sqlserver in LLBL Gen pro.

Not an urgent one! simple_smile

Reagrds Sujay

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 28-Apr-2005 16:33:41   

Mennisujay wrote:

Can i create aggregate functions on EntityCollection. If not is there any way that we can solve this thing. And also, how can we get the functionality of 'Distinct' keyword of Sqlserver in LLBL Gen pro.

There is no functionality build in for aggregate functions on already fetched entities in an entity collection, nor can you execute them while fetching an entity collection, as that wouldn't make sense, you're fetching objects, not values. If you want to have aggregated values, use a dynamic list.

DISTINCT is emitted when you fetch entities, or when you fetch a typed list/view and you specify false for 'allowDuplicates'

Frans Bouma | Lead developer LLBLGen Pro