Commit two delete sql command : Transactions : Database C# Source Code

    


using System;
using System.Data;
using System.Data.SqlClient;

   class SqlDemo {
      static void Main(){
         string connString = "server=(local)\\SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI";

         SqlConnection cn = new SqlConnection(connString);
         cn.Open();

         SqlTransaction objTrans = cn.BeginTransaction();

         try{
            SqlCommand cmd = cn.CreateCommand();
            cmd.CommandType = CommandType.Text;
            cmd.Transaction = objTrans;

            cmd.CommandText = "DELETE Employee WHERE Id = 222";
            cmd.ExecuteNonQuery();

            cmd.CommandText="DELETE Employee WHERE Id = 333";
            cmd.ExecuteNonQuery();

            objTrans.Commit();

            Console.WriteLine("Transaction Committed\n");
         }
         catch (System.Data.SqlClient.SqlException  ex)
         {
            objTrans.Rollback();  

            Console.WriteLine("Error - TRANSACTION ROLLED BACK\n" + ex.Message);
         }
         catch (System.Exception ex)
         {
            Console.WriteLine("System Error\n" + ex.Message);
         }
         finally
         {
            cn.Close();  
         }
      }
   }