Articles with "sql"

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.

Example SQL code
PostgreSQL revisited

Rediscovering PostgreSQL and highlighting some features.