Search categories:

Search results for "SQL":

Treating (complex) SQL views as entities in .NET with SQL triggers.

Did you know that you can use a SQL view for your entities in your favorite ORM framework? In this article I will discuss the reasons why one would do that (and why not). I will provide a case study where we try to achieve this, and try to find workarounds for problems that come along the way.

Advent of code 2023 - day 4 (SQL)

The elves are asking for help with their scratchcards. Over 200 of them! This is a sign of a serious gambling addiction. Now, usually I would not help them with such a task because it reinforces the addiction. On the other, this is a good programming practice, so it's a win-win ;) Today I'm using SQL to organize the cards and solve their problem.