Rollback SqlServer on writing two different tables

Question

Rollback SqlServer on writing two different tables

Navigation

#1 by (3 votes)

1

Premise:

I'm using EntityFramework6 for data persistence in SQLServer. At some point I need to write data in two different tables, but the second table has dependency on the first example.

try{

    MetodoPersisteNaTabelaA();

    MetodoPersisteNaTabelaB();

}
exception(Exception e){
    Erro();
}

I need if there is error writing table B that rolls back to table A.

sql-server c# entity-framework-6

asked by anonymous 08.02.2018 / 12:36

1 answer

Comparison of values in list of tuples in python 3.x Make Bootstrap 4 use 100% of screen height

score 3 · Accepted Answer

Good morning, in case you should be instantiating the connection at some point, either inside the method or in the construction of the class, in this connection, I suggest you use the transaction feature of the EF itself and after using the methods execute the committee of the context object or the rollback in case of error.

using (var context = new BloggingContext()) 
{ 
    using (var dbContextTransaction = context.Database.BeginTransaction()) 
    { 
        try 
        { 
            MetodoPersisteNaTabelaA();
            MetodoPersisteNaTabelaB();
            context.SaveChanges();
            dbContextTransaction.Commit(); 
        }
        catch (Exception) 
        { 
            dbContextTransaction.Rollback(); 
        } 
    }
}

Follow msdn's link with more explanations of the subject: link