即使未调用 System.Transactions.TransactionScope.Commit() 也提交了数据

问题描述

在什么情况下，包裹在 System.Transactions.TransactionScope 中的代码仍然可以提交，即使抛出了异常并且最外层的作用域从未被调用过?

Under what circumstances can code wrapped in a System.Transactions.TransactionScope still commit, even though an exception was thrown and the outermost scope never had commit called?

using (var tx = new TransactionScope()) 中有一个顶级方法，它以相同的方式调用也使用 TransactionScope 的方法.

There is a top-level method wrapped in using (var tx = new TransactionScope()), and that calls methods that also use TransactionScope in the same way.

我正在使用带有关联表适配器的类型化数据集.可能是由于某种原因适配器中的命令没有被登记吗?你们中有人知道如何检查他们是否在环境 TransactionScope 中登记吗?

I'm using typed datasets with associated tableadapters. Could it be that the commands in the adapter aren't enlisting for some reason? Do any of you know how one might check whether they are enlisting in the ambient TransactionScope or not?

推荐答案

结果是因为我创建了 TransactionScope 对象 after SqlConnection 对象.

The answer turned out to be because I was creating the TransactionScope object after the SqlConnection object.

我是从这里搬过来的:

using (new ConnectionScope())
using (var transaction = new TransactionScope())
{
    // Do something that modifies data

    transaction.Complete();
}

为此:

using (var transaction = new TransactionScope())
using (new ConnectionScope())
{
    // Do something that modifies data

    transaction.Complete();
}

现在它起作用了！

所以这个故事的寓意是创建您的TransactionScope 首先.

So the moral of the story is to create your TransactionScope first.