Windows error 0x8004D024, -2147168220

Using asynchronous save changes on Entity Framework with multiple contexts

I am using EF 6 with a UoW pattern. I have multiple contexts defined in my UoW since I'm using data from multiple databases. Everything seems to be working correctly except the CommitAsync function I have defined. Here's the code I have: public async Task CommitAsync() { try { using [...] read more

What is "The underlying provider failed on EnlistTransaction" Error in SQL?

I am having an application hosted in the IIS. My IIS and SQL were in difference systems.Using a single TransactionScope I am inserting into three different tables using Entity framework. Now I am getting the following error. "The underlying provider failed on EnlistTransaction" which have the inner exception as "Network [...] read more

Simple Transactions

I have 2 linq 2 SQL statements I'd like to be in a transaction (the SQL server is remote, outside firewalls etc) all other communication works but when I wrap these 2 statements in a TransactionScope() I begin having to configure MSDTC which we did, but then there are firewall [...] read more

Can multiple Entity Framework Data Contexts be used within a single TransactionScope?

I'm attempting to use multiple EntityFramework 6 DataContexts in a TransactionScope using{}. I get the following Exception > A first chance exception of type 'System.Data.Entity.Core.EntityException' > occurred in mscorlib.dll > > Additional information: The underlying provider failed on Open. Inner Exception 1 > Network access for Distributed Transaction Manager (MSDTC) [...] read more

Multiple stored procedure calls in 1 transaction with Entity Framework 5

I am using Entity Framework 5 and need to make multiple stored procedure calls in a single transaction. They are all inserts where each depends on an output of the previous one and I want to be able to roll everything back in case one fails. Each call uses the [...] read more

WCF windows service issue with MSDTC

I've a .net 3.5 windows service which uses msmq running on 2008 application server.This service communicates with the sql 2005 database on the database server. Am getting an error mentioned below on calling this service from my aspx page on 2008 web server: "Network access for Distributed Transaction Manager (MSDTC) [...] read more

TransactionScope, linq and strange transaction manager issue (HRESULT: 0x8004D024)

I have a service level methods, which make few changes to database and I want them to use transaction control. Such methods can do following: - LINQ SubmitChanges() functionality - Calls to StoredProcedures Component users can combine set of such elementary operations into something bigger. I see that there is [...] read more

WCF Transaction with multiple inserts

When creating a user, entries are required in multiple tables. I am trying to create a transaction that creates a new entry into one table and then pass the new entityid into the parent table and so on. The error I am getting is > The transaction manager has disabled [...] read more

What things should I consider when using System.Transactions in my EF project?

BACKGROUND I have both an MVC app and a windows service that access the same data access library which utilizes EntityFramework. The windows service monitors certain activity on several tables and performs some calculations. We are using the DAL project against several hundred databases, generating the connection string for the [...] read more

MSDTC Exception during Transaction: C#

I am getting a MSDTC exception in a Transaction in a C# application. The functionality is to upload one lakh (one hundred thousand) zipcode records into database tables after reading from a csv file. This operation is done in around 20 batch database operations (each batch containing 5000 records). The [...] read more

SQL Server database connections being dropped intermittently

Occasionally in one of our production environments (we have a dozen or so without different clients pointing to each) we get exceptions at different points in the process. The code doesn't do anything fancy - just your basic inserts and updates. We are however, performing multiple inserts and updates within [...] read more

The underlying provider failed on Open?

I created an application using the Entity framework 6 with SQL. It was working fine. suddenly yesterday I got an error twice from the entity framework as shown below, After that this issue not raised yet now. System.Data.Entity.Core.EntityException: The underlying provider failed on Open. ---> System.Transactions.TransactionManagerCommunicationException: Network access for Distributed [...] read more

Inconsistent behaviour with distributed transaction (MSDTC exception)

You may think this has been asked before, but hear me out first. I have a project that runs across different servers with remote connections. On the development server, all tests pass. In the QA server that has same configuration, most tests pass but a couple fail and the exception [...] read more

Insert into multiple tables using WCF Transactions

I am trying to add an entry into a table and use the primary key of that added entry to create an additional entry into another table. The error I am getting is > The transaction manager has disabled its support for remote/network > transactions. (Exception from HRESULT: 0x8004D024) I [...] read more

Simpleroleprovider causing remote transaction inside transactionscope

I am in the process of upgrading asp.net membership to the new simplemembership provider in MVC4. This is an Azure/Sql Azure app which runs fine on localhost but fails when deployed. I have code in a transaction as follows: TransactionOptions toptions = new TransactionOptions(); toptions.IsolationLevel = System.Transactions.IsolationLevel.Serializable; using (TransactionScope trans [...] read more

TransactionScope in a medium trust

Im running an ASP.NET MVC application hosted with Mosso, there are telling me that they cannot enable DTC because they run everything in medium trust. So when executing code that references: TransactionScope I get the following error. The transaction manager has disabled its support for remote/network transactions. (Exception from HRESULT: [...] read more

Removing .edmx from my project

I am using Code First with existing DB- Entity Framework 4.1, In my project i added .edmx file and generated schema, views stored procedures everything is working perfect, everything is in production. My problem is here 1- I moved my .edmx file,.tt to other project 2- Removed from working project [...] read more