Exemple #1
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();
            }
        }
Exemple #2
0
 public IDbConnection GetConnection()
 {
     return(new Npgsql.NpgsqlConnection(_serverInf.ToString()));
 }
Exemple #3
0
 public IDbConnection GetConnection(ServerInformation serverInf)
 {
     return(new Npgsql.NpgsqlConnection(serverInf.ToString()));
 }