Check if SQL connection is open or closed

Question

How do you check if it is open or closed? I used

if (SQLOperator.SQLCONNECTION.State.Equals("Open")) 

however, even the state is “open”, it is not executed during this check.

Answer 1

You must use SqlConnection.State

eg,

 if (myConnection != null && myConnection.State == ConnectionState.Closed) { // do something // ... } 

Answer 2

Here is what I use:

 if (mySQLConnection.State != ConnectionState.Open) { mySQLConnection.Close(); mySQLConnection.Open(); } 

The reason I am not just using:

 if (mySQLConnection.State == ConnectionState.Closed) { mySQLConnection.Open(); } 

This is because ConnectionState could also be:

 Broken, Connnecting, Executing, Fetching 

In addition to

 Open, Closed 

In addition, Microsoft states that Closing and then Reopening the connection will “update the status value”. See here http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnection.state(v = vs .110). Aspx

Answer 3

.NET documentation says: Status property: Bitwise combination of ConnectionState values

So, I think you should check

 !myConnection.State.HasFlag(ConnectionState.Open) 

instead

 myConnection.State != ConnectionState.Open 

since a state can have multiple flags.

Answer 4

Check if MySQL connection is open

 ConnectionState state = connection.State; if (state == ConnectionState.Open) { return true; } else { connection.Open(); return true; } 

Answer 5

you can also use this

 if (SQLCON.State == ConnectionState.Closed) { SQLCON.Open(); } 

Answer 6

This code is a bit more secure before you open the connection, check the status. If the state of the connection is Broken, we should try to close it. Broken means that the connection was previously open and does not work correctly. The second condition determines that the connection state must be closed before trying to open it again so that the code can be called again.

 // Defensive database opening logic. if (_databaseConnection.State == ConnectionState.Broken) { _databaseConnection.Close(); } if (_databaseConnection.State == ConnectionState.Closed) { _databaseConnection.Open(); } 

Answer 7

To check the status of the database connection, you can simply do the following

 if(con.State == ConnectionState.Open){} 

Answer 8

I am using the following sqlconnection.state method

 if(conexion.state != connectionState.open()) conexion.open();