516) Exam ple 7

You use Microsoft .Net framework 4 to develop an application that connects to a Microsoft SQL Server 2008 database. You need to prevent dirty or phantom reads.

Which IsolationLevel should you use?

Serializable.

some info with this.

The Serializable Isolation Model uses range locks to prevent transactions from inserting or deleting rows in a range being read by another transaction. The Serializable model protects against all three concurrency problems.