Jonathan Crozier, Author at Jonathan Crozier

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

Sometimes when developing an application that interacts with SQL Server, you may find the need to process a data set such that only one round trip needs to be made to and from the database server. The operation that is being carried out may be intended to operate on one set of data, or batches…

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

InWeb

Blazor WebAssembly facilitates the development of SPAs (Single-page applications) that run in the browser using C# instead of JavaScript as the primary programming language. Executing C# code in the browser is a rather neat trick, made possible via the revolutionary WebAssembly technology which is an open web standard. However, the default mechanism employed by Blazor…

Formatting JSON with proper indentation using PowerShell

InScripting

PowerShell is a powerful scripting language that makes working with data a breeze, allowing you to import and export to a variety of common file formats such as CSV, XML, and JSON. However, when it comes to JSON, the formatting applied by the built-in ConvertTo-Json cmdlet leaves a lot to be desired. While this may…

.NET 8 Blazor MSAL Error – There was an error trying to log you in: ‘”undefined” is not valid JSON’

InWeb

When developing a Blazor WebAssembly application that uses the MSAL (Microsoft Authentication Library) for .NET packages, you may encounter an error message similar to the following after trying to log in. There was an error trying to log you in: ‘”undefined” is not valid JSON’ The above error message is usually noticed after upgrading a…

How to dynamically build OR filters in an Entity Framework Core LINQ query

InProgramming

Entity Framework Core is an ORM (Object Relational Mapper) that allows us to leverage LINQ (Language Integrated Query) to abstract away the SQL (Structured Query Language) that would otherwise need to be written for interactions with a database. However, while LINQ is an awesome .NET feature, there are some limitations to be aware of when…

How to catch and parse a SQL Server Duplicate Key Exception

InProgramming SQL

When developing an application that connects to a SQL Server (or Azure SQL) database, you will often want to leverage the features that the database engine provides to help minimise checks that would otherwise need to be performed at the application level. By delegating these checks to the database, you can simplify your application logic,…

How to publish a .NET application as a standalone executable file

InProgramming

When you need to create a .NET application that can be easily deployed to a system without worrying about the installed .NET version or other dependencies, the publishing options that have been made available since .NET Core 3.0 are most welcome. If you are publishing a modern .NET application today, not only is it possible…

Encrypt directories and file names within a zip archive using 7-Zip

InTools

When storing or transmitting sensitive digital data, it is vital to take adequate measures to protect it against unintended disclosure that could harm your privacy or the privacy of others. Common examples of sensitive data include client files that need to be stored offline for a limited time, and documents containing customer details that need…

Finding and deleting duplicate records from a SQL Server database

InSQL

Sometimes duplicate data can make its way into a database, whether it be due to a software defect or as the result of an error that one or more users have made. Regardless of the cause, you may find yourself in a position where you need to find and delete duplicate records from a database….

How to fix scrolling issue after closing Google AdSense Consent dialog

InWeb

Since Google’s New Consent Management Platform requirements for serving ads in the EEA and UK came into effect this year (2024), websites that display Google AdSense advertisements must show a Consent dialog to users. This is part of IAB Europe’s Transparency and Consent Framework. One of my blog readers kindly pointed out that ever since…

Author: Jonathan Crozier