[Mono-list] MySql and System.Transactions

Luciano _ lnc19 at hotmail.com
Wed Oct 1 23:29:44 EDT 2008

    Is System.Transactions Support with MySql Connector? I try it and i get and error, my (test) code is something like this:

			using (System.Transactions.TransactionScope scope = new System.Transactions.TransactionScope()) {
				MySqlConnection connection = new MySqlConnection ("server=localhost;user id=myUser pwd=myPassdatabase=test");
				connection.Open ();
				MySqlCommand cmd = connection.CreateCommand ();
				cmd.CommandText = "INSERT INTO test(valor) VALUE('uno');";
				cmd.CommandType = CommandType.Text;
				cmd.ExecuteNonQuery ();
				connection.Close ();

				// scope.Complete(); //

I get:

Unhandled Exception: System.NotImplementedException: The requested feature is not implemented.
  at System.Transactions.Transaction.EnlistPromotableSinglePhase (IPromotableSinglePhaseNotification notification) [0x00000] 
  at MySql.Data.MySqlClient.MySqlConnection.EnlistTransaction (System.Transactions.Transaction transaction) [0x00000] 
  at MySql.Data.MySqlClient.MySqlConnection.Open () [0x00000] 
  at TestTransaction.MainClass.Main (System.String[] args) [0x00037] in ../TestTransaction/TestTransaction/Main.cs:39

I read in the mono site and i guess that is supported.

Thanks in advance.

Got Game? Win Prizes in the Windows Live Hotmail Mobile Summer Games Trivia Contest

More information about the Mono-list mailing list