Page 1 of 1
Model from database
Posted: Tue 02 Aug 2016 23:43
by rkevinburton
It seems the tutorial is out of date as it doesn't show VS 2015. I follow the tutorial by adding a new ADO.NET Entity Data Model. I select Code first from database. Then I am prompted for a "New Connection". When I select the "New Connection" I have to select a "provider". I only see the SQL providers and none for Postgresql. What have I done wrong? This is surely an FAQ but selecting that gives me a "page not found" in CRLab.
Thank you.
Kevin
Re: Model from database
Posted: Wed 03 Aug 2016 10:38
by Shalex
We recommend you to use Entity Developer (right click project in Solution Explorer > Add > New Item > Data > 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
- offers designer (Database First / Model First) for EF Core
- includes DbContext template
rkevinburton wrote:I follow the tutorial by adding a new ADO.NET Entity Data Model. I select Code first from database. Then I am prompted for a "New Connection". When I select the "New Connection" I have to select a "provider". I only see the SQL providers and none for Postgresql.
We cannot reproduce the problem with
https://www.devart.com/dotconnect/postg ... al_EF.html. Be aware that 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 check your current edition via the Tools > PostgreSQL > About menu of Visual Studio. Is it Professional?
Re: Model from database
Posted: Wed 03 Aug 2016 11:56
by rkevinburton
I don't get an option to add a Devart Entity Model item, *.edml) when I right click. I just added the Devart package from NuGet. What does that give me?
Kevin
Re: Model from database
Posted: Wed 03 Aug 2016 14:44
by Shalex