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