ado.net entity data model does not generate from database

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for PostgreSQL
Post Reply
Allgo
Posts: 1
Joined: Wed 22 Jun 2016 09:55

ado.net entity data model does not generate from database

Post by Allgo » Wed 22 Jun 2016 11:24

Hello,

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. devart.data; 2. devart.data.postgresql; 3. devart.data.postgresql.vs
- 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 ...

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: ado.net 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: http://www.devart.com/dotconnect/postgr ... tions.html. You can download a trial version (free use during 30 days) from http://www.devart.com/dotconnect/postgr ... 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: http://www.devart.com/entitydeveloper/ed-vs-edm.html. Additionally, Entity Developer adds registration of EF6 provider in app.config automatically.

Does this help?

Post Reply