Visual Studio Entity Framework connect to Postgres database

Question

I want to connect to a Postgres database using EntityFramework. Is that possible?

I select:

Add>>New Item>>ADO.Net Entity Data model>>Generate from database>>New connection

But I'm stuck there. I need to generate classes for the tables in the database.

How can I do this?

score 3 · Answer 1 · edited May 23 '17 at 11:51

3

The following question:

is extremely similar to yours, and covers the same ground. You will see references to npgsql there, and to Devart.

edited May 23 '17 at 11:51

Community

answered Aug 09 '12 at 00:43

Craig Ringer

score 2 · Accepted Answer · answered Aug 08 '12 at 07:22

2

The best solution to use PostgreSQL in combination with Entity Framework is the dotConnect provider from Devart.

You can find the PostgreSQL provider here:

answered Aug 08 '12 at 07:22

Eggi

2 Answers2