public static void CloseConnection() { if (null != _connection && _connection.State != ConnectionState.Closed) { _connection.Close(); _connection.Dispose(); _connection = null; } }