EF6 postgresql database first, can't generate model

Question

I'm following a tutorial to generate model for existing postgresql database.
I created a console application and added these NuGet packages:
EntityFramework (6.2.0), Npgsql(2.2.7), Npgsql.EntityFramework(2.2.7).

The problem is that I can't find PostgreSQL Database in the Data Source list while creating ADO.NET Entity Data model.

Does anyone know solution of the problem?

KevinLamb · Accepted Answer · 2019-04-29 15:36:04Z

2

You might need the Visual Studio extension for PostgreSQL. Then the option for connecting to the database should show up.

Right now you installed all the NuGet packages for your code to work but Visual Studio still needs the extension to be able to create entities from existing PostgreSQL databases.

Documentation: https://www.npgsql.org/doc/ddex.html

Extension: https://marketplace.visualstudio.com/items?itemName=RojanskyS.NpgsqlPostgreSQLIntegration

edited Apr 29, 2019 at 15:36

answered Apr 29, 2019 at 15:11

KevinLamb

6448 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Luciferous Over a year ago

Thank you very much! Now it works and I can go to another issue!

KevinLamb Over a year ago

@Luciferous, great to hear. Glad I could help

Luciferous Over a year ago

Yes, I'm just looking for button like "Answer is correct". This is my first experience of asking here.

Luciferous Over a year ago

sorry for molestation, but this option is disappeared again. I think it happened because I changed EF packages. Could it be the reason? Thank you in advance!

KevinLamb Over a year ago

Possibly, try to update to the latest packages if you can and make sure you have matching versions.

Collectives™ on Stack Overflow

EF6 postgresql database first, can't generate model

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related