Hello Friends,
How are you?? I am facing problem in ADO.NET entity framework. I want to impliment Rollback functionality using Entity frameowrk. I am trying to insert record in multiple tables in one transaction using  different contexts. My application scenario is given below:

EntityContainer ec = new EntityContainer();
//Make Entity Object
//Set all values of Entity and Call ec.AddToEntity() object
//Call: ec.SaveChanges();
//Make New Method for Other Entity
    --Make New Entity Container object by name ec2.
    --Set all values of Entity
    --and then SaveChanges of ec2
Now i've problem when ec1 successfully updated the value and if ec2 fails to Save values in table. Then all values from ec1 should also be Rollback. I am try to solve it by using "TransactionScope()" but it faiuls to commit changes. Code snippest is given below:
                          {
                              using (TransactionScope ts = new TransactionScope())
                                {

                                    ec1.AddToEntity(newObj);
                                    ec1.SaveChanges();                                                                    
                                    AddEntity2();
                                    ts.Complete();
                                }
                        }

AddEntity2()
{
           //Code for ec2 operations

           ec2.SaveChanges();
}

When it call ts.complete then it gives exception that: "The transaction has aborted".

Can anyone help us that how i can solve this issue??

Hello Sir,

I've solved rollback issue. But i am getting another exception while making transactions on Network. Description is given below:

"
I am finding a problem in Transaction scope  using entity framework. I've also started DTC services in windows services. It gives me Exception that "The underlying provider failed on Open.".  My inner exception detail is given below:

{"Network access for Distributed Transaction Manager (MSDTC) has been disabled. Please enable DTC for network access in the security configuration for MSDTC using the Component Services Administrative tool."}

{"The transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: 0x8004D024)"}

When i deploy my database on my own client machine it works properly. But when i deploy my data base on another machine. Then Transactionscope gives me error. Can anyone help me regarding this issue. Its very urgent. Waiting for quick response."