title: Possible to get SqlTransaction from ambient Transaction?
body: <p>Due to SQL Server's SavePoints feature (<code>SqlTransaction.Save()</code>), I would like to use <code>SqlTransactions</code> in a very limited fashion (I REALLY need this functionality) while still using ambient transactions in all other places. I realize that this means that this code (and dependencies) are now SQL Server-specific - this is fine. However, I'd still prefer to follow the preferred ambient transactions in all other places for best practice purposes. (If we need to move to Oracle or something, then we'll need to rework this part of our code but don't want to rework the entire codebase.)</p>
  
  <p>Is it possible to get a current <code>SqlTransaction</code> from <code>Transaction.Current</code> (which returns an object of type <code>System.Transactions.Transaction</code>) or some other way? (I may be wrong but I am guessing that this is ultimately the object that implements ambient <code>Transaction</code> object at run-time)</p>
  
  <p>(<a href="https://stackoverflow.com/questions/6988104/entity-framework-and-sql-server-savepoints">related but different question I'm currently working on if you need more info on why</a>)</p>