title: SqlConnection and nested transactions
body: <p>There's (still) no way to create nested transactions via ADO.NET / SQL Server 2012, correct? This ...</p>
  
  <pre><code>using (var sqlConnection = new SqlConnection(connStr))
  {
      sqlConnection.Open();
      var tranOuter = sqlConnection.BeginTransaction("outer");
      DoStuff();
  
          var tranInner = sqlConnection.BeginTransaction("inner");
          DoMoreStuff();
          tranInner.Commit();
  
  
      tranOuter.Commit();
  }  
  </code></pre>
  
  <p>... throws <strong>SqlConnection does not support parallel transactions</strong>. So I'll probably have to re-write my code to use <a href="http://msdn.microsoft.com/en-us/library/system.transactions.transactionscope.aspx" rel="nofollow noreferrer">TransactionScope</a> everywhere, or am I missing something?</p>
  
  <p>EDIT: naming transactions doesn't help</p>
  
  <p>EDIT: looks like this is a <a href="https://stackoverflow.com/questions/9909348/nested-transactions-in-ado-net">duplicate</a></p>