Articles with "dal"


Using Dapper Multi-Mapping with two Levels

When reading relational data with Dapper, most examples focus on one other entity, which may come in a 1:1 or 1:n relationship. In this blog post I will show how to extend it to two entities.


Data Access Layer Techniques

I have spent the last days exploring ways to map SQL result sets to objects as used in object-oriented programming languages as C# or Java. This process is known as object-relational mapping and is needed for all projects accessing data from a SQL database, the results must be converted to objects for further processing or sending them out as JSON.