A deadlock detected by the database will effectively rollback the transaction in which you were running (if any), while the connection is kept open in. net.
Retrying that operation (in that same connection),.
Deadlock happens when you have 2 different resources that 2 different threads need to lock in order to use them.
The threads lock them in the opposite order, so it becomes impossible for execution to.