Add drop database support for PostgreSQL

[knunery]

I would like to make a PR to add drop database support for PostgreSQL. Should I go ahead and make a PR for this @AdrianJSClark @droyad ?

[droyad]

Yes please

[mariusingjer]

Will we are waiting for the drop, you can do something like this in the meantime:

    public static void DropDatabase(string connectionString)
    {
        var builder = new NpgsqlConnectionStringBuilder(connectionString);

        var databaseName = builder.Database;
        builder.Database = "postgres";

        using (var connection = new NpgsqlConnection(builder.ToString()))
        {
            connection.Open();

            using (var command = new NpgsqlCommand($"SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = \'{databaseName}\'; DROP DATABASE IF EXISTS \"{databaseName}\"", connection))
            {
                command.ExecuteNonQuery();
            }

            connection.Close();
            Console.WriteLine("Dropped database {0}", databaseName);
        }
    }

[dncnkrs]

Given there hasn't been any movement here lately, and this feature would make some of my current projects easier, I'm currently working on this issue.

[MollsAndHersh]

What about using context.Database.EnsureDeleted()? Works like a charm for me.

[dncnkrs]

@MollsAndHersh Unfortunately EnsureDeleted Is an EF method, which not all projects will use.

[Obish]

@dncnkrs any luck with this feature?

[flatrick]

@Obish there has been a PR for this since 2020-11-07 (see PR 538).

@droyad is there anyway we can help with getting this issue/PR finished?
Looking around at issues and PRs, I get the feeling that this project is on the backburner for the project-owners, are you possibly interested in new blood to assist?

[aashikgowda]

I created a pull request for this feature.