c# multiple sql transactions in a connection code example
Example: c# sql transaction multiple connections
using(System.Transaction.TransactionScope myScope = new TransactionScope()){
//all of your sql connections and work in here
//call this to commit, else everything will rollback
myScope.Complete();
}