InSQL
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…
InWeb
Enable ahead-of-time (AOT) compilation for Blazor WebAssembly
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
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…
InWeb
.NET 8 Blazor MSAL Error – There was an error trying to log you in: ‘”undefined” is not valid JSON’
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
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
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
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…
InTools
Encrypt directories and file names within a zip archive using 7-Zip
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…
InCareer
