Beispiel #1
0
        public string CloseConnections()
        {
            if (_pooledConnection != null)
            {
                CustomConnectionPool.Instance.ReturnPooledConnection(_pooledConnection);
                _pooledConnection = null;
                return("Connection returned to pool.");
            }

            return("Connection already closed.");
        }
Beispiel #2
0
        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");
        }