Dapper Tutorial - Knowledge Base (KB)

C# Dapper loader in MS-SQL 2012 deadlocks on insert

Running Microsoft SQL 2012 standard, no compression, no partitions. Running on Windows Server 2008 R2. My loader program is VS C# 2013, pure 64 bit, .NET 4.5.2 I use Dapper 1.42 for my ORM. I do NOT use commit/rollback/transaction logic, these are just si...

SQL and Dapper Performance Implicit Conversion

How do we prevent SQL Implicit Conversions in Dapper? ...We realized, we were conducting an SQL Implicit conversion, causing an Index Scan and Deadlocks. Dapper parameters are nvarchar, while SQL table columns are varchar. This caused all our sql columns ...

Why did my async with ContinueWith deadlock?

I'm not after a solution here, more an explanation of what's going on.... I've refactored this code to prevent this problem but I'm intrigued why this call deadlocked. Basically I have a list of head objects and I need to load each ones details from a DB ...