[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