Jonathan Crozier, Author at Jonathan Crozier

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…

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…

How to paste JSON as Classes in Visual Studio: A hidden gem!

InProgramming Tools

In the increasingly fast-paced world of software development, efficiency is a critical factor for success in the marketplace. Visual Studio, Microsoft’s flagship IDE (Integrated Development Environment), is packed full of features designed to make your programming experience as productive as possible. Among these is a lesser-known feature that is extremely useful; the ability to paste…

A better way to convert enums to strings with Entity Framework Core

InProgramming

By default, Entity Framework Core stores and retrieves .NET enumerations as their underlying integer values for SQL databases, primarily for performance and storage optimization reasons. Nevertheless, if there is a requirement to store enums within your data model as strings at the database level, it is important to have a suitable way to configure this…

Query to find table names in a SQL Server database

InSQL

When working in a SQL Server or Azure SQL database containing many tables, I often find the need to search for tables with names that contain a specific keyword. This is particularly true when working with an unfamiliar schema. While tools like Azure Data Studio provide easy ways to search by table name, I find…

Converting CSV files with values containing commas to JSON using C#

InProgramming

CSV (Comma-separated values) remains an extremely popular file format, and, in the context of programming, it is particularly useful for importing and exporting data between different software applications. One of the issues with CSV, or any other delimiter-separated file format, is that often the values that need to be parsed into separate ‘parts’ will contain…

Communicating with ASP.NET Core hosted services from API endpoints using Channels

InAPIs Web

Hosted services are a powerful .NET feature, providing a robust mechanism for executing long-running background tasks in different types of applications. Given the flexible nature of .NET, such applications could be running on client devices, on-premise servers, or the cloud, depending on the particular use case. When it comes to ASP.NET Core, hosted services are…

Store and retrieve enums as strings with Entity Framework Core

InProgramming

C# enumeration types (enums) provide a highly extensible and type-safe way of storing values and they are used frequently in .NET software development. When enums are saved to a SQL database with Entity Framework Core, by default they are stored using their underlying integer values rather than as strings. There are several reasons for this…

Author: Jonathan Crozier

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

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

Finding and deleting duplicate records from a SQL Server database

How to fix scrolling issue after closing Google AdSense Consent dialog

How to paste JSON as Classes in Visual Studio: A hidden gem!

A better way to convert enums to strings with Entity Framework Core

Query to find table names in a SQL Server database

Converting CSV files with values containing commas to JSON using C#

Communicating with ASP.NET Core hosted services from API endpoints using Channels

Store and retrieve enums as strings with Entity Framework Core

How to keep the host window open after executing a PowerShell script

Using the STRING_AGG function in T-SQL to concatenate row data

How to print SQL Server messages to the output immediately