1

Hi everyone and thanks for taking the time to see my question.

I'm running VS 2017 with Entity Framework 6 and asp.net MVC and have to add some field to one of my Entities.

I added the corresponding fields in the database, but when I open the edmx file nothing shows apart the message "Entity Data Model Designer is unable to open this file." and it proposes me to open it in XML editor, but I have not the "Update model from Database" option when right clicking on the XML file.

Is anyone knows what causes this ?

Pierrick Martellière
  • 1,554
  • 3
  • 21
  • 42

1 Answers1

2

I finally came accross my problem. I searched for like 5 hours how to make a new database connection and realised I had no option with MySQL connection. So I found this thread and it led me on the good path. After, I found this cause I weren't able to install MySQL for Visual Studio. I followed these two steps:

  • Download and install the MySQL for Visual Studio component without the MySQL installer here

    • Download and install the "Connector/NET" V6.9.10. "mysql-connector-net-6.9.10.msi" here

After that I started Visual Studio and the Design Surface showed up well, and I was directly able to Update my model from the Database :D

EDIT: I just saw that MySQL for visual studio wasn't installed properly. In fact, it rolls back up at the end of the installation, and I have no Mysql Database option on the "new Database connection" window :/ Does somebody know what this is about ?

EDIT SOLUTION Turns out that I had installed Visual Studio on an other disk than C: and mysql for visual studio Installer didn't like that. Now I see "MySql Database" in the list when adding a new connection.

Pierrick Martellière
  • 1,554
  • 3
  • 21
  • 42