entity data model does not generate from database

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Posts: 1
Joined: Wed 22 Jun 2016 09:55 entity data model does not generate from database

Post by 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 ...

Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

Re: entity data model does not generate from database

Post by Shalex » Thu 23 Jun 2016 08:49

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

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?

Post Reply