对了,事务是以connection 为基础的,当你new SqlConnection时又新开一个tranSaction ,所以不回滚.这样写就行了
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open(); using (SqlTransaction transaction = connection.BeginTransaction())
{
try
{
}
}
}
using (SqlConnection connection = new SqlConnection(ConnectionString))
{
connection.Open(); using (SqlTransaction transaction = connection.BeginTransaction())
{
try
{
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货