Is there a standard .NET way to test if a SqlConnection string works?

Question

Possible Duplicate:
How to check if connection string is valid?

Currently I'm doing it like this:

internal bool CheckConnection()
{
    using (SqlConnection testConn = new SqlConnection(this.ConnectionString))
    {
        try
        {
            testConn.Open();
        }
        catch (SqlException)
        {
            return false;
        }
    }
    return true;
}

Is there a better way to do this?

It is a duplicate. Would delete if i could. – Chris Pfohl Dec 02 '10 at 19:00 — Chris Pfohl, Dec 02 '10 at 19:00

Paul Sasik · Accepted Answer · 2010-12-02T17:28:26.490

4

That is pretty much the way to do it. Though you should think about handling some other exception types as well. There can be other reasons why you don't connect to a db server besides a sql issue.

Connection.Open can throw InvalidOperationException and ArgumentException in addition to SqlException. Also the APIs that .Open calls can throw other types of exceptions that can percolate to your code as well. In fact, this is one of the rare instances when it might be preferable to handle the base exception and display its message to the user. (The general rule of thumb is to handle only the specific exceptions.)

edited Dec 02 '10 at 17:28

answered Dec 02 '10 at 17:14

Paul Sasik

79,492
20
149
189

1

Very true: The database could be valid but the network is down, server is being re-booted etc. – John Warlow Dec 02 '10 at 17:19

score 0 · Answer 2 · answered Dec 02 '10 at 17:15

0

Nop, there's not... that's the only way

What you can is catching the SqlException and return a little more info inc ase of fail depending on the Number in the exception

answered Dec 02 '10 at 17:15

sebagomez

9,501
7
51
89

Is there a standard .NET way to test if a SqlConnection string works?

2 Answers2