/// <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);
}
