3.6.3 使用System.Transaction命名空间

using(TransactionScope scope = new TransactionScope())
{
/**//* Perform transactional work here */
//No errors - commit transaction
scope.Complete();
}

using(TransactionScope scope1 = new TransactionScope())
//Default is Required
{
using(TransactionScope scope2 = new 
TransactionScope(TransactionScopeOption.Required))
{}
using(TransactionScope scope3 = new
TransactionScope(TransactionScopeOption.RequiresNew))
{}
using(TransactionScope scope4 = new 
TransactionScope(TransactionScopeOption.Suppress))
{}
}

using (TransactionScope transScope = new TransactionScope())
{
using (SqlConnection connection1 = new 
SqlConnection(connectString1))
{
// Opening connection1 automatically enlists it in the 
// TransactionScope as a lightweight transaction.
connection1.Open();
// Do work in the first connection.
// Assumes conditional logic in place where the second
// connection will only be opened as needed.
using (SqlConnection connection2 = new 
SqlConnection(connectString2))
{
// Open the second connection, which enlists the 
// second connection and promotes the transaction to
// a full distributed transaction. 
connection2.Open();
// Do work in the second connection.
}
}
//  The Complete method commits the transaction.
transScope.Complete();
}