The underlying provider failed on EnlistTransaction. RRS feed

  • Question


    I am using MyDirect.net 4.7 (devart) as provider of entity framework to connect with mysql database and

    going to open a transation scope while saving entites in a loop . When I have called transactionScope.Complete();

    to commit transaction , I have got a error "The underlying provider failed on EnlistTransaction.". and the Inner exception was "Specified method is not supported."


    My Code was looking like these :

    using (TransactionScope transactionScope = new TransactionScope(System.Transactions.TransactionScopeOption.Required,TimeSpan.FromMinutes(30)))


    string dbConnection = System.Configuration.ConfigurationManager.ConnectionStrings["DBEntities"].ConnectionString;

    DBEntities context = new DBEntities(dbConnection);



    Console.WriteLine(set.Name + " data are going to insert....");

    //method In Server Side

    if (!InsertDataIntoDB(ref context, orderedList))


    IsAllImportedSuccessfully = false;




    if (IsAllImportedSuccessfully)




    Is that limitation of MyDirect.net ? or did I do somthing wrong? Its workis fine with SQL server.

    Thursday, November 6, 2008 3:17 PM


  • The exception is thrown when the underlying provider or the server doesnt support distributed transaction. I would recommend following up with the owner of the ADO.Net Provider to see if System.Transaction is supported.

    Monday, November 17, 2008 11:00 PM