下面的代码为什么没有进行回滚 IDbConnection dbconn = db.CreateConnection();
dbconn.Open();
IDbTransaction Idbtran = dbconn.BeginTransaction();
try
{
db.ExecuteNonQuery(CommandType.Text, "Insert Into [Author](FirstName,LastName) Values('han1','wei1')"); db.ExecuteNonQuery(CommandType.Text, "Update [Author] Set LastName = 'wei1xiu' where FirstName=han1"); Idbtran.Commit();
}
catch
{
Idbtran.Rollback();
}
finally
{
dbconn.Close();
}
dbconn.Open();
IDbTransaction Idbtran = dbconn.BeginTransaction();
try
{
db.ExecuteNonQuery(CommandType.Text, "Insert Into [Author](FirstName,LastName) Values('han1','wei1')"); db.ExecuteNonQuery(CommandType.Text, "Update [Author] Set LastName = 'wei1xiu' where FirstName=han1"); Idbtran.Commit();
}
catch
{
Idbtran.Rollback();
}
finally
{
dbconn.Close();
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货