using System; using System.Data; using System.Data.SqlClient; class ExecuteTransaction { public static void Main() { SqlConnection mySqlConnection =new SqlConnection("server=(local)SQLEXPRESS;database=MyDatabase;Integrated Security=SSPI;"); mySqlConnection.Open(); SqlTransaction mySqlTransaction = mySqlConnection.BeginTransaction(); SqlCommand mySqlCommand = mySqlConnection.CreateCommand(); mySqlCommand.Transaction = mySqlTransaction; mySqlCommand.CommandText = "INSERT INTO Employee (" + " ID, FirstName" + ") VALUES (" + " 10, 'Jason'" + ")"; Console.WriteLine("Running first INSERT statement"); mySqlCommand.ExecuteNonQuery(); mySqlCommand.CommandText = "INSERT INTO Employee (" + " ID, FirstName" + ") VALUES (" + " 11, 'Jason'" + ")"; Console.WriteLine("Running second INSERT statement"); mySqlCommand.ExecuteNonQuery(); Console.WriteLine("Committing transaction"); mySqlTransaction.Commit(); mySqlConnection.Close(); } }