Posted on: 4/22/2015 4:09:59 AM | Views : 590

Hi Team , 
I wanted To use transaction , in Entity Framework 4.0 .  Purpose of the transaction is   I have Written a linq Code which saves the records using Entity  .
and After that , I m saving another records , in Remote database  using link Server Concept , For that i Wriiten  the Stored Procedure , and saving in second database using ADO.Net.    If  in Worst cases , if the remote Server is down ,  Switched off , or not responding or any Error Occurs .   I want to Rollback the changes  that i saved in first database using entity framework. please let me know how to do this.
Below is code logic , 
{
// Linq Code to Add in First Database 

// Ado.net records in the Second remote Database. 

My Concern is the server While Saving in second database ,  Whatever the records i saved should get  rollback .

}
...

Go to the complete details ...