Is there a way to easily convert a flat DataTable to a nested .NET object?

Question

I have a large hand tuned SQL query that returns a flat data table with many (>25) columns.

Currently, I manually convert that to a .NET object with three levels of nesting (i.e. an object which contains (among other properties) a list of further objects which contains (among other properties) a list of further objects.

Is there anything with the ease of something like AutoMapper which can convert a DataTable into a target .NET object, even if its nested?

@PhillyNJ Yes, but this is not suitable in this situation. I need this to be an ultra fast query, so a hand optimized SQL query is what I have to start with. This is proving to be at least an order of magnitude faster than Entity Framework. Due to political reasons, I cant slot in another heavyweight ORM framework, so I have to do this particular series of queries manually. — Contango
– Contango, Commented May 4, 2015 at 15:00

Community · Accepted Answer · 2017-05-23 12:06:36Z

2

I am the original poster of this question.

It turns out that I was asking the wrong question: I should have been asking how to easily perform fast queries which map into a complex arrangement of POCOs.

I have posted the solution that worked perfectly for me, see How do I write one to many query in Dapper.Net? and the answer that references Dapper + Slapper.Automapper.

edited May 23, 2017 at 12:06

CommunityBot

11 silver badge

answered May 6, 2015 at 15:36

Contango

81k59 gold badges283 silver badges324 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Is there a way to easily convert a flat DataTable to a nested .NET object?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related