大家好，又见面了，我是你们的朋友全栈君。
![transactionscope mysql,如何将TransactionScope与MySql和多个数据库服务器一起使用[通俗易懂]](http://javaforall.cn/wp-content/themes/justnews/themer/assets/images/lazy.png)
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.
发布者：全栈程序员-用户IM，转载请注明出处：https://javaforall.cn/161951.html原文链接：https://javaforall.cn
【正版授权，激活自己账号】： Jetbrains全家桶Ide使用，1年售后保障，每天仅需1毛
【官方授权 正版激活】： 官方授权 正版激活 支持Jetbrains家族下所有IDE 使用个人JB账号...
