Handling concurrency in an ASP.NET Core Web API with Dapper

A simple but effective approach for handling concurrency in an ASP.NET Core Web API endpoint, where the resource is persisted in a SQL Server database.