Programming for Joy A blog about .NET, Angular, Powershell, and enterprise architecture.

Ranking results in a subquery using ROW_NUMBER()

Using the ROW_NUMBER() window function to add a rank column.

Command Line Basics: grep

How to use grep for simple searching of directories and files.

Creating complex objects with Dapper

How to build nested objects from complex queries with joins using Dapper ORM.