.net 7 template with postgresql and dapper for database
sudo -u postgres psql
postgres=# create database db1;
postgres=# create user admin with encrypted password 'admin';
postgres=# grant all privileges on database db1 to admin;
SELECT * FROM pg_stat_activity;dotnet runvisit http://localhost:5238/index.html to see the swagger API available