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;
}
