备忘
1. 亲测(可以嵌套使用)
using (TransactionScope scope = new TransactionScope())
{
//操作1
XXEntities.Current.SaveChanges(); //操作2
XXEntities.Current.SaveChanges(); //其他Context操作
XXEntities2.Current.SaveChanges(); scope.Complete();
BoshccEntities.Current.AcceptAllChanges();
}
2.
XXEntities.Current.Connection.Open();
using (var tran = XXEntities.Current.Connection.BeginTransaction())
{
try
{
//....
XXEntities.Current.SaveChanges();
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
XXEntities.Current.Connection.Close();
tran.Dispose();
}
}