entity-framework - Entity Framework 事务和 sql azure 默认隔离级别

Question

根据这篇文章 http://social.technet.microsoft.com/wiki/contents/articles/handling-transactions-in-sql-azure.aspx

SQL Azure default database wide setting is to enable read committed 
snapshot isolation (RCSI) 

我是否正确假设:

A) 以下代码默认为Serializable(覆盖数据库默认)

        using (TransactionScope transaction = new TransactionScope())
        {                                                               

        }

B) 以下代码默认为 ReadCommitted with Snapshot Isolation(而不仅仅是普通的 ReadCommitted)

        TransactionOptions options = new TransactionOptions();
        options.Timeout = TimeSpan.FromMinutes(1);
        options.IsolationLevel = IsolationLevel.ReadCommitted;

        using (TransactionScope transaction = new 
          TransactionScope(TransactionScopeOption.Required, options))
        {                                                               

        }

Answer 1

a) 是的。默认情况下，隔离级别将是可序列化的。 http://msdn.microsoft.com/en-us/library/ms172152(v=vs.90).aspx

b) 对于该事务，隔离级别将仅为 ReadCommitted。对于快照，您需要

  options.IsolationLevel = IsolationLevel.Snapshot;

http://msdn.microsoft.com/en-us/library/system.data.isolationlevel.aspx