entity data model does not generate from database entity data model does not generate from database

Postby Allgo » Wed 22 Jun 2016 11:24


I'm trying to use dotConnect for postgresql (Express v7.6) .
I add an ADO.NET Entity Data Model (from database) I can create a new connection with my postgresql database and when I click next, the window is closed without asking me the table I want to choose and the model is not generated.
Here is what I ve done step by step:

- create a new project
- I run the following command in the package manager console: Install-Package Npgsql.EntityFramework
- right click on reference and select: 1.; 2.; 3.
- I manually add this in App.config: <provider invariantName="Devart.Data.PostgreSql" type="Devart.Data.PostgreSql.Entity.PgSqlEntityProviderServices,
Devart.Data.PostgreSql.Entity.EF6, Version=7.6, Culture=neutral, PublicKeyToken=09af7300eec23701" />

- Right click on my project / add component / ADO.NET / From database / New connection
a) I set the data source to "postgreSQL Server" with dotConnect for postgre as dataprovider.
b) I test the connection it works
c) I check "yes, include the sensitive ..."
d) Next
e) Nothing ... the window is closed and the model is not generated

Thank you and sorry for my English I'm not a native speaker ...
Posts: 1
Joined: Wed 22 Jun 2016 09:55

Re: entity data model does not generate from database

Postby Shalex » Thu 23 Jun 2016 08:49

1. The Entity Framework support is available only in the Professional edition of dotConnect for PostgreSQL: You can download a trial version (free use during 30 days) from

2. dotConnect for PostgreSQL doesn't use the Npgsql provider.

3. We recommend you to use Entity Developer (the Devart Entity Model item, *.edml) instead of EDM Designer (the ADO.NET Entity Data Model item, *.edmx) because it is adjusted for working with PostgreSQL and has an advanced functionality: Additionally, Entity Developer adds registration of EF6 provider in app.config automatically.

Does this help?
Devart Team
Posts: 7893
Joined: Thu 14 Aug 2008 12:44

Return to dotConnect for PostgreSQL