title: Is it possible to use System.Transactions.TransactionScope with SqlBulkCopy?
body: <p>Very simple question: is it possible to use <code>System.Transactions.TransactionScope</code> together with <code>SqlBulkCopy</code>? The documentation <a href="http://msdn.microsoft.com/en-us/library/tchktcdk%28v=VS.100%29.aspx">Transaction and Bulk Copy Operations</a> doesn't mention anything (at least as of .NET 4.0) and my testing indicates it does not automatically enlist with <code>TransactionScope</code>. </p>