استفاده از Transaction

بر گرفته از MSDN

// This function takes arguments for 2 coection strings and commands to create a transaction 
// involving two SQL Servers. It returns a value > 0 if the transaction is committed, 0 if the 
// transaction is rolled back. To test this code, you can coect to two different databases 
// on the same server by altering the coection string, or to another 3rd party RDBMS by 
// altering the code in the coection2 code block.
static public int CreateTransactionScope(
string coectString1, string coectString2,
string commandText1, string commandText2)
{
// Initialize the return value to zero and create a StringWriter to display results.
int returnValue = 0;
System.IO.StringWriter writer = new System.IO.StringWriter();try
{
// Create the TransactionScope to execute the commands, guaranteeing
// that both commands can commit or roll back as a single unit of work.
using (TransactionScope scope = new TransactionScope())
{
using (SqlCoection coection1 = new SqlCoection(coectString1))
{
// Opening the coection automatically enlists it in the 
// TransactionScope as a lightweight transaction.
coection1.Open();// Create the SqlCommand object and execute the first command.
SqlCommand command1 = new SqlCommand(commandText1, coection1);
returnValue = command1.ExecuteNonQuery();
writer.WriteLine("Rows to be affected by command1: {0}", returnValue);// If you get here, this means that command1 succeeded. By nesting
// the using block for coection2 inside that of coection1, you
// conserve server and network resources as coection2 is opened
// only when there is a chance that the transaction can commit.   
using (SqlCoection coection2 = new SqlCoection(coectString2))
{
// The transaction is escalated to a full distributed
// transaction when coection2 is opened.
coection2.Open();// Execute the second command in the second database.
returnValue = 0;
SqlCommand command2 = new SqlCommand(commandText2, coection2);
returnValue = command2.ExecuteNonQuery();
writer.WriteLine("Rows to be affected by command2: {0}", returnValue);
}
}// The Complete method commits the transaction. If an exception has been thrown,
// Complete is not  called and the transaction is rolled back.
scope.Complete();}}
catch (TransactionAbortedException ex)
{
writer.WriteLine("TransactionAbortedException Message: {0}", ex.Message);
}
catch (ApplicationException ex)
{
writer.WriteLine("ApplicationException Message: {0}", ex.Message);
}// Display messages.
Console.WriteLine(writer.ToString());return returnValue;
}