Always room for growth

Table Valued Parameters and Dapper in .NET Core

A customer I’ve been working with for a while now has a monolithic ASP.NET MVC web application which we are porting to .NET Core 3.1 (and then almost immediately to .NET 6). One of our biggest changes was getting rid of Entity Framework and replacing it with Dapper, because performance is a feature. To deflect
-> Continue reading Table Valued Parameters and Dapper in .NET Core

Xero logo

Using the Xero OAuth 2.0 API from a .NET Core console application

[Edited on 5 August 2021 with some pseudocode at the end.] This is not a post about SQL Server, but I need to write about something that I’ve been struggling with for a number of weeks so that other people don’t have to. A few months ago Xero announced that they would be moving their
-> Continue reading Using the Xero OAuth 2.0 API from a .NET Core console application

The easy way to handle UTF-8 in a .NET application when dealing with SQL Server 2019

A short post this week. On a mailing list recently, someone noticed that a .NET application writing to SQL Server did not have the expected behaviour with UTF-8 collation and data types. To refresh our memories, UTF-8 is newly supported in SQL Server 2019, and provides potential savings of up to 50% when storing strings,
-> Continue reading The easy way to handle UTF-8 in a .NET application when dealing with SQL Server 2019