You are developing an ASP.NET MVC application that reads and writes data from a SQL Server database.
You need to prevent the application from reading data that is locked by other transactions. You also need to
prevent exclusive range locks.
Which isolation level should you use?
A.
ReadCommitted
B.
Serializable
C.
Repeatable
D.
ReadUncommitted
Read committed seems to be wrong as this lock does not prevent exclusive locks (range of rows it affects).
Should be Repetable in my opinion https://docs.microsoft.com/en-us/sql/odbc/reference/develop-app/transaction-isolation-levels
2
1
“prevent exclusive range locks”, A sounds right.
3
1
Agreed. Repeatable and Serializable perform range locks.
1
0
“ReadCommitted” is correct.
“Repeatable” is not a correct isolation level. There’s only “Repeatable read”.
1
0