public static ConnectionTestResult TestConnectionString(string connectionString, bool closeConnection = false) { var result = new ConnectionTestResult(); if (!String.IsNullOrWhiteSpace(connectionString)) { SqlConnection sqlConnection = new SqlConnection(connectionString); try { sqlConnection.Open(); if (closeConnection) { sqlConnection.Close(); } result.Success = true; } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } } else { result.Success = false; result.ErrorMessage = "Connection string cannot be empty"; } return(result); }
public static ConnectionTestResult TestConnectionString(string connectionString, bool closeConnection = false) { var result = new ConnectionTestResult(); if (!String.IsNullOrWhiteSpace(connectionString)) { SqlConnection sqlConnection = new SqlConnection(connectionString); try { sqlConnection.Open(); if (closeConnection) { sqlConnection.Close(); } result.Success = true; } catch (Exception ex) { result.Success = false; result.ErrorMessage = ex.Message; } } else { result.Success = false; result.ErrorMessage = "Connection string cannot be empty"; } return result; }