.NET Core Archives - Jonathan Crozier

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

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…

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…

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…

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…

How to replace accented characters with plain characters using C#

InProgramming

The majority of software applications developed today need to work with strings that contain accented characters such as à and é since many human languages use these to indicate variations in pronunciation and other subtleties. Even English borrows some French words that contain accents and other glyphs, such as café, déjà vu, and façade. These…

Substituting Moq for NSubstitute

InProgramming

In light of the recent controversy surrounding the .NET Moq library, many developers are reconsidering their choice of mocking framework for unit testing. The undisclosed inclusion of the proprietary SponsorLink DLL that reportedly extracts internal developer email addresses and uploads them to a remote server has undoubtedly been alarming to many. Beyond the immediate privacy…

Taming Nullable Reference Types in C#

InProgramming

The term Nullable Reference Types refers to a set of features introduced in C# 8.0 that help us to write cleaner, more robust code that is resistant to unintended null dereferencing. The features that are provided make us aware of possible null reference exceptions that could occur in our applications, reducing the likelihood of encountering…

Getting the path to a C# member via a lambda expression

InProgramming

Are you looking for a way of getting the path to a C# property, or some other type of object member, as a string and want to do so in a strongly-typed manner? For example, perhaps you are building your own API error response model and you want your error messages to contain member names…

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…

Tag: .NET Core

How to catch and parse a SQL Server Duplicate Key Exception

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

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

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

Store and retrieve enums as strings with Entity Framework Core

How to replace accented characters with plain characters using C#

Substituting Moq for NSubstitute

Taming Nullable Reference Types in C#

Getting the path to a C# member via a lambda expression

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

How to catch and parse a SQL Server Duplicate Key Exception

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

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