Programming Archives - Jonathan Crozier

How to create and read encrypted zip files with C#

If you ever find the need to create a password-protected zip file using C#, you’ll quickly discover that the options are much more limited than you might expect. The built-in System.IO.Compression .NET types (ZipArchive and ZipFile classes) unfortunately do not support any kind of encryption mechanism. Therefore, if you need to produce a zip archive…

Auto-Registering and injecting multiple Handler Interfaces in ASP.NET Core

InAPIs Programming

When building ASP.NET Core applications, it is common practice to implement multiple classes that share a common interface, particularly when working with design patterns such as Chain of Responsibility or when dispatching work to a set of discrete handlers. A typical example of this might be a collection of INotificationHandler, ICommandHandler, or IEventHandler implementations that…

Getting started with GitHub Copilot in Visual Studio

InProgramming

GitHub Copilot is a revolutionary AI-powered coding assistant that helps developers write code faster, reducing effort and freeing up time to focus on problem-solving and collaboration. For decades, aside from their own experience, developers have relied on online resources such as Stack Overflow and various forms of documentation, where available, to assist with the development…

Maximize .NET LINQ performance using ZLinq

InProgramming

LINQ is one of the standout features of .NET and is loved by many C# developers, for whom it has become second nature in their day-to-day work. The declarative nature of LINQ allows for expressive queries over collections to be composed, resulting in highly readable and maintainable code. However, while LINQ provides powerful abstractions and…

.NET Run File: Run C# code with no project file!

InProgramming Scripting

The world of .NET is in a constant state of evolution, with the pace of framework improvements steadily increasing, especially following the advent of the cross-platform .NET Core in 2016. Over the past few years, Microsoft has been working hard to increase the adoption of the C# language among new software developers, who often choose languages…

Exploring SQL Server JSON mapping support in Entity Framework Core 9

InProgramming SQL

JSON is a ubiquitous format for defining structured data, and it is increasingly common to see it being stored directly in databases that are primarily relational in nature. Over the past several years, Entity Framework Core has steadily improved its support for JSON, culminating in first-class JSON mapping support in EF Core 8 and EF…

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

InProgramming SQL

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…

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…

Category: Programming

How to create and read encrypted zip files with C#

Auto-Registering and injecting multiple Handler Interfaces in ASP.NET Core

Getting started with GitHub Copilot in Visual Studio

Maximize .NET LINQ performance using ZLinq

.NET Run File: Run C# code with no project file!

Exploring SQL Server JSON mapping support in Entity Framework Core 9

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

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

How to catch and parse a SQL Server Duplicate Key Exception

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

How to create and read encrypted zip files with C#

Validating and Sanitising filenames in a Blazor WebAssembly app

Auto-Registering and injecting multiple Handler Interfaces in ASP.NET Core