sqltransaction的BeginTransaction()冻结，如何使用try catch来解决它

我在c#应用程序中使用SqlTransaction transaction = connection.BeginTransaction()从SQLServer获取数据。

问题我有当没有连接到服务器(没有互联网连接)，然后我的应用程序只是冻结和停止工作，没有异常，没有错误，只是冻结。

我尝试使用try catch来捕获错误，但即使这样应用程序只是冻结，唯一的选择是杀死应用程序。谁能帮我抓住这个错误，而不是冻结给我错误-像Connection to server failed. Please check internet connection.

下面是我的连接类代码:

public static class RequestID
{
    // Methods
    public static int GetID(string server, string database, string user, string pass)
    {
        int num = 0;
        using (SqlConnection connection = new SqlConnection(string.Format("server={0};database={1};uid={2};pwd={3};Connect Timeout=900", new object[] { server, database, user, pass })))
        {
            SqlCommand command = new SqlCommand("SELECT Value_Int FROM Param WHERE code= 'counter'");
            SqlCommand command2 = new SqlCommand("UPDATE Param SET Value_Int = Value_Int + 1 WHERE code= 'counter'");
            if (connection.State != ConnectionState.Open)
            {
                connection.Open();
            }
            try
            {
                using (SqlTransaction transaction = connection.BeginTransaction())
                    {
                        try
                        {
                            command.Connection = connection;
                            command.Transaction = transaction;
                            command2.Connection = connection;
                            command2.Transaction = transaction;
                            num = (int)command.ExecuteScalar();
                            command2.ExecuteNonQuery();
                            transaction.Commit();
                        }
                        catch (Exception)
                        {
                            transaction.Rollback();
                            throw;
                        }
                        finally
                        {
                            if (connection.State != ConnectionState.Closed)
                            {
                                connection.Close();
                            }
                        }
                    }
                }
            catch (Exception ex)
            {
                throw;
            }            

            return num;
        }
    }
}

问题在行:

using (SqlTransaction transaction = connection.BeginTransaction())

提前感谢。

注:应用程序工作正常，到目前为止唯一的问题是失去了网络连接。

connection.Open();