CODEWITHSUNDEEP
c#sql-serverisolation-leveldatabase-deadlocks
Anto Varghese
Anto Varghese

Reputation: 3251

Will isolation level change during a database transaction?

In our C# application, we have not set isolation level, so i assume the default isolation level is going as Read Committed. However during a deadlock, we could see that lockmode of the application is

isolationlevel="serializable (4)"

What it mean by serializable(4) ? Also will the isolation level auto-convert to some other during a transaction?

Upvotes: 1

Views: 460

Answers (1)

Anto Varghese
Anto Varghese

Reputation: 3251

For helping others, i am posting the solution we found. We were using transaction with help of TransactionScope with its default constructor. Its default isolation level is serializable which made the confusion. Now corrected it to use Read Committed as the isolation level explicitly.

Upvotes: 1

Related Questions