/// <summary> /// Creates a new/gets the existing connection. /// </summary> /// <returns></returns> private NpgsqlConnection CreateConnection() { if (_connection == null) { _connection = new NpgsqlConnection(_connectionString); _connection.Open(); if (_createAndDetectSchema) { // creates or detects the tables. PostgreSQLSchemaTools.CreateAndDetect(_connection); } } if (_connection.State != System.Data.ConnectionState.Open) { _connection.Open(); } return(_connection); }