I have been exploring how to access Postgres from C#. When using prepared statements ( which I almost always want to do) the website recommends the following:

Trying to upgrade Npgsql from version 6, to version 8.

I have some code like this in C# and npgsql and I do not get an idea how to handle the situation, if OpenConnectionAsync() fails.

I have created a temporary table with an npgsql command and if there is an error in my code, after I cannot find my temporary table! I know that postgres don’t drop temporary table inside the connection but only when I close the connection.
This is a sample test code:

I have a background service that runs scheduled tasks as well as looks for notification events in PostgreSQL. Every 30 minutes or so the following function gets called.