public bool ExistsDatabase() { var newServerInfoWithMasterDatabase = new ServerInformation(DbType.Postgress, _serverInf.Server, "postgres", _serverInf.UserId, _serverInf.Password); using (var conn = GetConnection(newServerInfoWithMasterDatabase)) { conn.Open(); var command = conn.CreateCommand(); command.CommandText = $"select * from pg_database where datname = '{_serverInf.Database}'"; var reader = command.ExecuteReader(); var data = new DataTable(); data.Load(reader); return(data.Rows.Count > 0); } }
public void Createdatabase() { if (ExistsDatabase()) { return; } var newServerInfoWithMasterDatabase = new ServerInformation(DbType.Postgress, _serverInf.Server, "postgres", _serverInf.UserId, _serverInf.Password); using (var conn = new Npgsql.NpgsqlConnection(newServerInfoWithMasterDatabase.ToString())) { conn.Open(); var command = conn.CreateCommand(); command.CommandText = $"CREATE DATABASE \"{_serverInf.Database}\" "; command.ExecuteNonQuery(); conn.Close(); } }
public DatabaseFactory(ServerInformation serverinfo) { ServerInformation = serverinfo; }
public IDbConnection GetConnection(ServerInformation serverInf) { return(new Npgsql.NpgsqlConnection(serverInf.ToString())); }
public PostgreSQLCreator(ServerInformation serverInf) { _serverInf = serverInf; }