tags:

views:

142

answers:

1
+2  Q: 

Managing transactions using ADO.Net Entity framework - Update multiple databases

Hi,

I need to update multiple databases in one transaction using entity framework. Means if we need to insert records in two tables of two different databases and insertion succeeds for first database but fails for other database then insertion in first database should also get rolled back.

Please let me know if we can do this using entity framework.

Thanks

Sharad Rastogi

+1  A: 

Managing Connections and Transactions (Entity Framework)

You can use a TransactionScope to accomplish what you require.

How to: Manage Transactions in the Entity Framework

TransactionScope and ADO.NET Entity Framework

Mitch Wheat  2010-06-02 09:32:51
I have two edmx files and don't know how to use transaction scope for the same as all the examples I have seen have only one edmx files. can you provide any sample that shows transaction management usign two data models (edmx files).
 2010-06-22 14:12:57

related questions

SQL tracing LINQ to Entities
SQL Anywhere 11 (Sybase) with Entity Framework in Visual Studio SP1?
ADO.NET Entity Framework and identity columns
Is anyone using Entity Framework with an Oracle database?
LINQ to entities - Building where clauses to test collections within a many to many relationship.
Entity Framework: how to return a base type from L2E
Unit Testing in .NET: How to Mock Entity Data Provider
Entity Framework - Can you map the result type of an imported stored procedure to a custom entity type?
Entity Framework and Application Architecture (loose coupling, etc)
Can you use Microsoft Entity Framework with Oracle?
Using MySQL with Entity Framework
How to Implement Database Independence with Entity Framework
What is the best data access paradigm for scalability?
ADO.NET Entity Framework tutorials
How do you create a database from an EDM?
Anyone using the Entity Framework *Well*?
What real-world usages of ADO.NET Entity Framework do you know?
Which ORM framework can best handle an MVCC database design?
Where to start with Entity Framework
How to customize Entity Framework classes?
Linq to Entities vs ESQL
ADO.NET Entity vs NHibernate
Update database schema in Entity Framework
Expression.Invoke in Entity Framework?
Entity Framework vs LINQ to SQL