Hi there,

I have 2 Tables related: Section and Subsection. (A Section can have many SubSections)

Subsection has one attribute that is a foreign key for table Sections.

So, on the generated code, i have a Section Entity, that has one attribute that is a Collection of SubSections.

The "problem" is that, when, for example, i need to get the information for one section, and just a few attributes from that section's subsections.

I don't want to retrieve all of that information, just a part of it.

How can i do that??

Thanks in advance

Take a look at using a dynamic list to fetch only the information you want. If you do this you will be working with tables instead of collections, but you will be able to choose the data that you want returned.