[Mono-list] MySql and System.Transactions
    Luciano _ 
    lnc19 at hotmail.com
       
    Wed Oct  1 23:29:44 EDT 2008
    
    
  
Hi:
    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.
Luciano
_________________________________________________________________
Got Game? Win Prizes in the Windows Live Hotmail Mobile Summer Games Trivia Contest
http://www.gowindowslive.com/summergames?ocid=TXT_TAGHM
    
    
More information about the Mono-list
mailing list