transactionscope mysql,如何将TransactionScope与MySql和多个数据库服务器一起使用[通俗易懂]

TransactionOptions TransOpt = new TransactionOptions();

TransOpt.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;

TransOpt.Timeout = new TimeSpan(0, 2, 0);

using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, TransOpt))

{

MySqlConnection conn = null;

conn = new MySql.Data.MySqlClient.MySqlConnection(ConfigurationManager.ConnectionStrings[“_ConnectionString”].ConnectionString);

conn.Open();

MySqlCommand objCmd;

objCmd = new MySql.Data.MySqlClient.MySqlCommand(query1, conn);

objCmd.ExecuteNonQuery();

MySqlConnection conn2 = null;

conn2 = new MySql.Data.MySqlClient.MySqlConnection(ConfigurationManager.ConnectionStrings[“dbUpload_ConnectionString”].ConnectionString);

conn2.Open();///error line

MySqlCommand objCmd2;

objCmd2 = new MySql.Data.MySqlClient.MySqlCommand(query2, conn2);

objCmd2.ExecuteNonQuery();conn.Close();

conn2.Close();

scope.Complete();

}

When I run this, I get the error:

Multiple simultaneous connections or connections with different connection strings inside the same transaction are not currently supported

解决方案

Please close the first connection before opening the next one.