I’ve been trying to figure out the cause of a SQL deadlock problem, and it dawned on me that preventing deadlocks shouldn’t be that hard. You just have to save data in the same order every time, and the easiest way to do that is to have a repository with one save method.

I'll show you what a deadlock is, and how to prevent them.

#sql #csharp #database

Blog:
https://betterwithcode.com/

LinkedIn:
  / jeffzuerlein2aa67b7  

To find deadlocks in your database...
SP_BlitzLock:
https://github.com/BrentOzarULTD/SQL...

00:00 Introduction
00:40 Example Aggregate
01:08 What is a deadlock?
02:54 Fixing the repository.
03:51 Tools to find problems.