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 ...
ado.net entity data model does not generate from database
Re: ado.net entity data model does not generate from database
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?
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?