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'