You are developing an ASP.NET MVC application that reads and writes data from a SQL Server database. You need to maintain data integrity including retrieving identical sets across reads in all situations that use transactions. Which isolation level should you use?
A. Repeatable
B. Serializable
C. ReadUncommitted
D. ReadCommitted
Answer:D
You are developing an ASP.NET MVC application that reads and writes data from a SQL Server database. You need to maintain data integrity including retrieving identical sets across reads in all situations that use transactions. Which isolation level should you use?
A. Repeatable B. Serializable C. ReadUncommitted D. ReadCommitted