Explicit Transaction : SqlTransaction « ADO.Net « C# / CSharp Tutorial

1. C# / CSharp Tutorial
2. ADO.Net
3. SqlTransaction

using System;
using System.Data;
using System.Data.SqlClient;
using System.Transactions;
using System.Collections.Generic;
using System.Text;

    class Program
    {
        static void Main(string[] args)
        {
            CommittableTransaction tx = new CommittableTransaction();

            SqlConnection conn = new SqlConnection("data source=localhost; initial catalog=SampleDB; integrated security=SSPI;");
            conn.Open();

            SqlCommand updateCommand = conn.CreateCommand();
            updateCommand.CommandText = "DELETE Employees WHERE ID > 3";

            conn.EnlistTransaction(tx);

            updateCommand.ExecuteNonQuery();

            tx.Rollback();

            conn.Close();
        }
    }