c# - 连接突然中断时 ADO.Net 事务的命运

Question

考虑下面的示例代码。

如果在第 2 步(即第 2 个命令)时与数据库的连接突然断开，那么即使我们尝试回滚事务也不会回滚，因为没有与数据库的连接服务器。

在这种情况下，数据库服务器端的事务对象会发生什么情况？ 会一直处于等待模式吗？ 我当我尝试通过 VPN 连接到数据库服务器来在 ADO.Net 中运行长事务时，遇到过这种情况。

using (SqlConnection connection =
        new SqlConnection(connectionString))
{
SqlCommand command = connection.CreateCommand();
SqlTransaction transaction = null;

try
{
    // BeginTransaction() Requires Open Connection
    connection.Open();

    transaction = connection.BeginTransaction();

    // Assign Transaction to Command
    command.Transaction = transaction;

    // Execute 1st Command
    command.CommandText = "Insert ...";
    command.ExecuteNonQuery();

    // Execute 2nd Command
    command.CommandText = "Update...";
    command.ExecuteNonQuery();

    transaction.Commit();
}
catch
{
    transaction.Rollback();
    throw;
}
finally
{
    connection.Close();
}

Answer 1

连接中止将触发任何未决事务的回滚。参见 Controlling Transactions :

If the client's network connection to an instance of the Database Engine is broken, any outstanding transactions for the connection are rolled back when the network notifies the instance of the break