Use Of Transaction In EntityFramework

The important use of transaction is that it can execute multiple operations in a single transaction. In other words, a transaction is used to perform operations in a single unit of work. Whenever we execute SaveChanges() extension method to insert, update or delete on the database this framework will wrap these operations in a transaction. Entity Framework transactions are a part of its internal architecture. Entity Framework starts a new transaction for each operation and completes the transaction when the operation finishes.

Introduction

 

The important use of transaction is that it can execute multiple operations in a single transaction. In other words, A transaction is used to perform operations in a single unit of work. Whenever we execute SaveChanges() extension method to insert, update or delete on the database this framework will wrap these operations in a transaction. Entity Framework transactions are a part of its internal architecture. Entity Framework starts a new transaction for each operation and completes the transaction when the operation finishes. We can achieve these all using  BeginTransaction() extension method of Entity framework and it has introduced in EF6.

BeginTransaction contains:

• Commit
• Rollback 
• Underlying transaction
  
• Dispose

Commit

 

COMMIT Extension method is used to end our current transaction and make permanent all changes performed in the transaction

 

Rollback

 

Rolls back an extension method for an explicit or implicit transaction to the beginning of the transaction. Main use is to erase all data modifications made from the start of the transaction 

 

Dispose

 

Dispose extension method is used to Releases the resources that are held by the respective object.

 

Underlying transaction

 

It's used to provide the information about sqlTransaction and sqlConnection. 

 

Okay! Let us use these all following examples

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace Transaction {
    class Program {
        static void Main(string[] args) {
            using(CSharpCornerEntities databaseEntities = new CSharpCornerEntities()) {
                using(var transaction = databaseEntities.Database.BeginTransaction()) {
                    try {
                        var TransactionInfo = transaction.UnderlyingTransaction;
                        if (TransactionInfo.Connection != null) {
                            Console.WriteLine("UnderlyingTransaction Has Connection info.,");
                        }
                        Employee employee = new Employee();
                        employee.Designation = "Software Engineer";
                        employee.Location = "Noida";
                        employee.Name = "Record 1";
                        databaseEntities.Employees.Add(employee);
                        Employee employee1 = new Employee();
                        employee1.Designation = "Software Engineer";
                        employee1.Location = "Mumbai";
                        employee1.Name = "Record 2";
                        databaseEntities.Employees.Add(employee1);
                        databaseEntities.SaveChanges();
                        transaction.Commit();
                        var TransactionInfo1 = transaction.UnderlyingTransaction;
                        if (TransactionInfo1.Connection == null) {
                            Console.WriteLine("UnderlyingTransaction is not have connection information");
                        }
                        foreach(var item in databaseEntities.Employees) {
                            Console.WriteLine("Name : " + item.Name);
                        }
                    } catch (Exception ex) {
                        transaction.Rollback();
                    }
                }
            }
        }
    }
}

Now run your application

 

 

 

If any error occurs during this transaction it will rollback all operations using Rollback() extension method in a catch block.

 

I hope it's helpful