Npgsql version should be upgraded

[toizo]

Is there an existing issue for this?

• I have searched the existing open and closed issues

Description

I see that currently, this package uses Npgsql v3.2.7, that was released in 2018. This is a version that is out of support and therefore I believe it should be updated to at least v6, if not the latest (v8).

What is the impact?

Apart from possible security issues, there are some breaking changes, e.g. we could not use VerifyFull SSL mode in our connection string.

[toizo]

I checked out this repo and see that it's probably due to your support of netstandard1.3. I also noticed that it is planned to be dropped in the next major release, so the upgrade will be possible. I will stay tuned.

[droyad]

Fixed by #17