Articles with "sql"
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.
SQL Date Range Queries
In my company work, we often use two _Date_ or _DateTime_ fields to express a range when the row data is valid.
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.