Hello,

I am trying to use DataProjectorToCustomClass to project data read from my tables onto my own classes. My question is how to handle nested data. I have classes nested several levels deep. Each class contains a List<t> to hold the children. The use of List<t> is up for debate as well. Maybe there's a better structure?

Is there a way to do a deep read and then project the results onto my deep class structure? Assuming not, how would you suggest I work around this limitation?

Thank you,

Rick

Using v2.6 Adapter

Please check Hierarchical projections of entity collections

Walaa wrote:

Please check Hierarchical projections of entity collections

It mentions projecting onto DateSets and Dictionaries. What about custom classes? Is there an example anywhere?

Thank you,

Rick

There is a sample in the documentation here

Matt

Maybe I am missing something. This topic is about how to handle nested projections. I don't see that in the example.

Thanks,

Rick

Is Linq an option?

Walaa wrote:

Is Linq an option?

Sure. The question is, what is the best way to handle projcting nested database objects onto a class structure.

Thanks,

Rick

Linq would be the best way to do it.

See: http://www.llblgen.com/documentation/2.6/Using%20the%20generated%20code/Linq/gencode_linq_generalusage.htm#HierarchicalSets

the example is with entities, but you can also project to anonymous types or custom classes.