ADO.NET SQLServer:如何防止关闭连接持有S-DB锁？

using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();
    // 执行SQL命令
}

SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
// 执行SQL命令
connection.Close();

SqlConnection connection = new SqlConnection(connectionString);
connection.Open();

SqlTransaction transaction = connection.BeginTransaction();

try
{
    // 执行多个SQL命令
    transaction.Commit();
}
catch (Exception ex)
{
    transaction.Rollback();
}
finally
{
    connection.Close();
}

SqlConnection connection = new SqlConnection(connectionString);
// 执行SQL命令