Error loading table definition of a PostgreSQL table

When a PostgreSQL table name contains uppercase letters there is no known way to get the table definition SQL script. When we right-click a table name in SQLPro for Postgres the has an uppercase letter and select Script as, CREATE to, New query window we get the error message /* * Error loading table definition. * ERROR: […]

Reverse engineer a database with AspNetCore in Visual Studio

For some reason the .NETCore designers did not think, that developers want to follow best practices by separating the data layer from the presentation layer. The Entity framework out of the box only works if the database is accessed from the main application project. When we try to reverse engineer a PostgreSQL database from a […]