title: entity framework transactions and sql azure default isolation level
body: <p>According to this article <a href="http://social.technet.microsoft.com/wiki/contents/articles/handling-transactions-in-sql-azure.aspx" rel="nofollow">http://social.technet.microsoft.com/wiki/contents/articles/handling-transactions-in-sql-azure.aspx</a></p>
  
  <pre><code>SQL Azure default database wide setting is to enable read committed 
  snapshot isolation (RCSI) 
  </code></pre>
  
  <p>Am I right in assuming that:</p>
  
  <p>A)  The following code defaults to Serializable (overriding the database default)</p>
  
  <pre><code>        using (TransactionScope transaction = new TransactionScope())
          {                                                               
  
          }
  </code></pre>
  
  <p>B)  The following code it defaults to ReadCommitted with Snapshot Isolation (and not just plain ReadCommitted)</p>
  
  <pre><code>        TransactionOptions options = new TransactionOptions();
          options.Timeout = TimeSpan.FromMinutes(1);
          options.IsolationLevel = IsolationLevel.ReadCommitted;
  
          using (TransactionScope transaction = new 
            TransactionScope(TransactionScopeOption.Required, options))
          {                                                               
  
          }
  </code></pre>