Month: March 2023

Query to list the number of rows for each table in a SQL Server database

When working with a SQL Server database, I often find it helpful to have a SQL query to hand that can be executed to tell me how many rows exist within each database table. This can be useful in scenarios where records are being inserted into lots of tables and you need to check that…

How to get the Local AppData directory for all Windows users within a .NET application

InProgramming

Local AppData is a directory within the Windows operating system where software applications can store data that is specific to the current user. Getting the location of the Local AppData directory for the current user within a .NET application is straightforward. However, currently, there isn’t a .NET API that allows you to get the Local…

Month: March 2023

Query to list the number of rows for each table in a SQL Server database

How to get the Local AppData directory for all Windows users within a .NET application

Introduction to the SQL Server MERGE statement

Operating on data via a SQL Server Stored Procedure efficiently with Table-Valued Parameters using C#

Enable ahead-of-time (AOT) compilation for Blazor WebAssembly