Allow use of NpgsqlDataSource with Posgresql persistence #1760
Description
Describe the feature.
Is your feature related to a problem? Please describe.
Version 7.* and up of Npgsql introduced the NpgsqlDataSource API and recommend that it be used.
It's unknown what the potential negative consequences of not using this API are.
Describe the requested feature
Allow a single NpgsqlDataSource to be used to create connections for use for PostgreSQL persistence.
Currently the the only API available would is the ConnectionBuilder which doesn't have access to the Dependency Injection container, and would require the recreation of a NpgsqlDataSource each time that a connection needs to be created. This is in contrast with how the NpgsqlDataSource is designed to be used.
Describe alternatives you've considered
Using the standard NpgsqlConnection works, but according to the documentation if you are using Version 7 or above this is "discouraged for various reasons"
Additional Context
No response