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