Hello,

I was wondering how to do a group by clause in LLBLGEN.. I have looked around and cant see how to add a group by clause to how we are getting EntityCollections.

Sample code here :

RelationPredicateBucket filter = new RelationPredicateBucket();

        filter.PredicateExpression.Add( SuggestionsAndBugsFields.Show == true );
        filter.PredicateExpression.Add( SuggestionsAndBugsFields.SuggestionStatusId == SuggestionStatusTypes.Fixed );
        filter.PredicateExpression.Add( SuggestionsAndBugsFields.SuggestionTypeId == SuggestionTypes.Bug );

        EntityCollection<SuggestionsAndBugsEntity> suggestions = new EntityCollection<SuggestionsAndBugsEntity>( new SuggestionsAndBugsEntityFactory() );

        SortExpression sorter = new SortExpression( SuggestionsAndBugsFields.DateCreated | SortOperator.Descending );

        return SuggestionsAndBugsManager.FetchCollection( suggestions, filter, 0, sorter );

Is there an easy way to Group By a field doing it the way we are doing it ?

Thanks in advance..

Hi Buzzy,

You probably want to be looking at TypedLists when doing Aggregates / GroupBy's. The help (found in the LLBLGen Pro Designer) has some excellent examples for you.

Hope this helps!

Ryan

rdhatch is correct. You can't use GroupBy with entityCollections, rather you should use a TypedList or a DynamicList.