Today I lost way too much time trying to understand why I couldn’t see data in a PostgreSQL database running inside a Docker container. I was connected via DBeaver, everything looked fine:

• connection successful
• schemas visible
• but no tables

To Run PostgreSQL in Docker I use an official image ‘postgres’ from https://hub.docker.com/_/postgres. You can start it as it’s described in the documentation, but I prefer to use docker-compose. For me it’s more flexible and allows to avoid of errors when start form command line.

Create a console app with .Net Framework 4.7.2 with Dapper and datasource in MSSQL Server or PostgreSQL.

If you create this ancient app, you should only add Dapper and NPGSQL packages from Nuget. The support of MS SQL Server is already built in. The scenario for .Net Framework is from real life, several applications still require this framework.