Use of a transaction

image_pdfimage_print
   

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