SqlBulkCopy Tutorial - Knowledge Base (KB)

Is System.Transactions.TransactionScope compatible with SqlBulkCopy?

Very simple question: is it possible to use ...System.Transactions.TransactionScope... together with ...SqlBulkCopy...? The documentation ...Transaction and Bulk Copy Operations... doesn't mention anything (at least as of .NET 4.0) and my testing indicate...

SqlBulkCopy Timeout when used within a WCF Sercive that sets TransactionScopeRequired

Situation: WCF Service with TransactionScopeRequired OperationBehaviour. WCF Service runs a process that used SqlBulkCopy to insert many rows to a db....When used without the TransactionScopeRequired behaviour, the SqlBulkCopy inserts records with no issu...

Parallel.Invoke(), TransactionScope() and SqlBulkCopy

I have multiple methods inside a ...Parallel.Invoke()... that need to run inside of a transaction. These methods all invoke instances of ...SqlBulkCopy... The use-case is "all-or-none", so if one method fails nothing gets committed. I am getting a ...