Transaction roll back and commit

image_pdfimage_print
   


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();

            objTrans.Commit();
        
            Console.WriteLine("Transaction Committed
" );
         }
         catch (System.Data.SqlClient.SqlException ex)
         {
            objTrans.Rollback();
            Console.WriteLine("Error - TRANSACTION ROLLED BACK
" + ex.Message);
         }
         catch (System.Exception ex)
         {
            Console.WriteLine("System Error
" + ex.Message);
         }
         finally
         {
            cn.Close();
         }
      }
   }