public string CloseConnections() { if (_pooledConnection != null) { CustomConnectionPool.Instance.ReturnPooledConnection(_pooledConnection); _pooledConnection = null; return("Connection returned to pool."); } return("Connection already closed."); }
public string Connect() { try { _pooledConnection = CustomConnectionPool.Instance.GetConnection(GetConnectionString(_connectionParameters)); if (_pooledConnection.State == ConnectionState.Open) { return("Connection retreived from pool"); } _pooledConnection.Open(); } catch (Exception e) { return(String.Format("Failed to connect. {0}", e.Message)); } return("Opened pooled ADO.Net connection"); }