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