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.


Using OData

Exploring the use of OData for fetching data.


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.


PostgreSQL revisited

Rediscovering PostgreSQL and highlighting some features.