Getting Distinct values from a collection

Posts   
 
    
VBAHole22
User
Posts: 18
Joined: 12-Nov-2008
# Posted on: 12-Nov-2008 21:21:04   

I am a complete newbie to llblGen so please bear with me. I used designer to create an entity against my Oracle 10g database. I then took the generated code and dumped it in my c# solution. I can create an entity collection and pull back all of the records in code. Now I want to only pull back all unique values from a specific field within the table. How do I go about doing that?

I'm using GetMulti in my code. I am using the SelfServicing template also.

Thanks for any advice at all.

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 13-Nov-2008 03:59:07   

Are you looking for a GroupBy approach? You cant distinct on a EntityCollection. You need to use a DynamicList with groupby collection.

David Elizondo | LLBLGen Support Team