Model from database

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
rkevinburton
Posts: 2
Joined: Tue 02 Aug 2016 20:58

Model from database

Post by rkevinburton » Tue 02 Aug 2016 23:43

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

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

Re: Model from database

Post by Shalex » Wed 03 Aug 2016 10:38

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?

rkevinburton
Posts: 2
Joined: Tue 02 Aug 2016 20:58

Re: Model from database

Post by rkevinburton » Wed 03 Aug 2016 11:56

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

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

Re: Model from database

Post by Shalex » Wed 03 Aug 2016 14:44


Post Reply