title: TransactionScope promoting to MSDTC although I am using the same connection string
body: <p>I have two repositories that point to the same SQL Server 2008 R2 (10.50.2550.0) database. One repository is based on Entity Framework, the other uses regular SqlConnection. I need to perform an operation that involves both, so I have used a <code>TransactionScope</code> to keep them in the same transaction:</p>
  
  <pre><code>using (TransactionScope scope = new TransactionScope(TransactionScopeOption.RequiresNew, new TransactionOptions() { IsolationLevel = IsolationLevel.RepeatableRead }))
  {
     _repoA.DoStuff();
     _repoB.DoStuff();
  }
  </code></pre>
  
  <p>Since I use the same connection string in both: </p>
  
  <pre><code>"Data Source=(local);Initial Catalog=mydb;User Id=myid;Password=mypass;Asynchronous Processing=true"
  </code></pre>
  
  <p>I was expecting that <a href="https://stackoverflow.com/questions/1690892/transactionscope-automatically-escalating-to-msdtc-on-some-machines">SQL Server 2008 R2 could use multiple connections without scalating</a>.
  Unfortunately I get an exception saying:</p>
  
  <blockquote>
    <p>System.Data.SqlClient.SqlException occurred   Message=MSDTC on server
    'MyComputer' is unavailable.   Source=.Net SqlClient Data Provider<br>
    ErrorCode=-2146232060   Class=16   LineNumber=1   Number=8501<br>
    Procedure=""   Server=(local)   State=2   StackTrace:
           at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)</p>
  </blockquote>
  
  <p>What could be the problem?</p>
  
  <p>Cheers.</p>