November 2023 - Jonathan Crozier

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

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…

Month: November 2023

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

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

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

Formatting JSON with proper indentation using PowerShell