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 ...