使用具有亚音速的事务

类似:

Using ts As New System.Transactions.TransactionScope()
  Using sharedConnectionScope As New SubSonic.SharedDbConnectionScope()

' Do your individual saves here

' If all OK
      ts.Complete()

   End Using
End Using

这个 answer 由给定 @Kevinw 很好。我发布这篇文章只是为了翻译他的答案。我不使用注释,因为它不会格式化代码:)我还使用try/catch来确定事务是应该完成还是应该回滚。

using (System.Transactions.TransactionScope ts = new TransactionScope())
{
    using (SharedDbConnectionScope scs = new SharedDbConnectionScope())
    {
        try
        {
            //do your stuff like saving multiple objects etc. here 

            //everything should be completed nicely before you reach this
            //line if not throw exception and don't reach to line below
            ts.Complete();
        }
        catch (Exception ex)
        {
            //ts.Dispose(); //Don't need this as using will take care of it.
            //Do stuff with exception or throw it to caller
        }
    }
}

不。如果我把 SharedDbConnectionScope 在更改之外,以前可以在数据库中看到 ts.Complete() . 把它放进去会阻塞服务器,直到操作完成。