Postgresql with Entity Framework 6 (database first approach) Postgresql with Entity Framework 6 (database first approach) postgresql postgresql

Postgresql with Entity Framework 6 (database first approach)


Yes this is possible. First, add this extension to Visual Studio 2019 Community Edition (the IDE I used): Npgsql PostgreSQL Integration

Npgsql PostgreSQL Integration

Then, using Nuget package manager, add:

  • EntityFramework6.Npgsql
  • Npgsql

And then you can proceed to add your ado.net entity data model/ database. Tables will be added nicely but I had a challenge with functions and views.