locked
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);

    try

    {

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

    //method In Server Side

    if (!InsertDataIntoDB(ref context, orderedList))

    {

    IsAllImportedSuccessfully = false;

    }

     

              }catch(Exception){}

    if (IsAllImportedSuccessfully)

    transactionScope.Complete();

    }

     

    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

Answers

  • 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