Serializable: Prevents dirty, non-repeatable, and phantom reads. This is the most?

restrictive but guarantees the highest level of consistency.

You set the isolation level using the Transaction object:

SqlTransaction transaction =

connection.BeginTransaction(IsolationLevel.Serializable);