using System.Data.Common;
using System.Data.SqlClient;
using System.Transactions;
class Program {
   static void Main() {
      string sCnx1 =
        "server = localhost ; uid=sa ; pwd =; database = ORGANIZATION";
      string sCnx2 =
       "server = localhost ; uid=sa ; pwd =; database = ORGANIZATION2";
      string sCmd1 =
    "DELETE FROM EMPLOYEES WHERE Surname='Smith' AND Firstname='Adam'";
      string sCmd2 =
    "INSERT INTO EMPLOYEES VALUES ('COM','Smith','Adam','(123) 456-7899')";
      try {
         using ( TransactionScope txScope = new TransactionScope() ) {
            Transaction.Current.TransactionCompleted += OnTxCompleted;
            TransactionManager.DistributedTransactionStarted += 
                                            OnDistributedTxStarted;
            using ( SqlConnection cnx1 = new SqlConnection(sCnx1) ) {
               cnx1.Open();
               DbCommand cmd = new SqlCommand(sCmd1, cnx1);
               cmd.ExecuteNonQuery();
            } // end using cnx1.
            using (SqlConnection cnx2 = new SqlConnection(sCnx2)) {
               cnx2.Open();
               DbCommand cmd = new SqlCommand(sCmd2, cnx2);
               cmd.ExecuteNonQuery();
            } // end using cnx1.
            txScope.Complete();
         } // end using txScope, the transaction terminates here.
      } catch { }
   }
   static void OnTxCompleted(object sender, TransactionEventArgs e) {
      Transaction tx = e.Transaction;
      System.Console.WriteLine("Completed! Status:" + 
                         tx.TransactionInformation.Status.ToString());
   }
   static void OnDistributedTxStarted(object sender, 
                                      TransactionEventArgs e) {
      Transaction tx = e.Transaction;
      System.Console.WriteLine("Distributed tx started!");
   }
}