C# Data Access: Complex Objects with Dapper

Tim Corey explains how to map flat SQL query results into complex nested objects using Dapper in C#.

In C#, we deal with complex objects that have nested objects inside of them. In SQL, a query returns flat rows. Those two structures don't match up well. Entity Framework allows us to return complex objects, not just rows. But how do we do the same thing using Dapper? In this video, we will look at how to load Order objects, each with a list of order details inside of them. We will look at multiple ways to accomplish the task using Dapper, as well as how this can be much more efficient than the default method in Entity Framework. Full Training Courses: DevForge.com Source Code: DevForge.com/downloads/?code=DapperComplexObjects Mailing List: signup.iamtimcorey.com/