Can't Create Entity Data Model - using MySql and EF6

Question

I'm trying to add an edmx Entity model to my C#/Web Project in Visual Studio 2013. My problem is that the file is not created.

I do the following steps:

Give the item a name
Choose 'EF Designer from database'
Choose the connection from the drop down (localhost) that already tested successfully connecting to MySQL databse
The "Save connection settings in webc.config as" option is checked
I click 'Next' AND the window disappeared and I get back to the code window

No edmx file is created. (although it works with SQL Server, but not for MySQL)

I have Entity Framework 6.1.2 installed, MySql.Data, MySql.Data.Entities, MySql.Data.Entity, MySql.Web -- all installed.

I also rebuilt the project before trying to add an entity model file.

I've installed the latest MySQL package with the latest .NET connector.

Running: Visual Studio 2013 on Windows 7.

Any ideas how to solve this?

Any possibility that the file was created but not included in the solution automatically? — Yasir, Jan 30 '15 at 18:29
@Yasir Yes, it is there. I tried "update model from database" again from within the designer (diagram), but it just closes the window without doing anything. — Liron Harel, Jan 30 '15 at 18:31
can you attach screenshots of your solution explorer and the folder structure you have? Next, if you see the edmx file open, close it, right click on it and open with XML editor. Search for the words 'error' and 'exception' and post what you find. — Yasir, Jan 30 '15 at 23:33
I have the exact same problem. Did you find a solution yet ? Please let me know.. — DR., Feb 22 '15 at 11:49
A workaround for Core is here https://stackoverflow.com/a/58324837/7149454 — Nick Kovalsky, Oct 10 '19 at 14:05

score 81 · Answer 1 · edited Jul 10 '21 at 04:12

81

I just had the same situation when trying to configure Visual Studio Professional 2017 environment with MySQL, ADO.NET (Database First) and EF6.

Note: Please follow steps in the same order.

Uninstall/remove "Connector/NET" and "MySQL for Visual Studio" if installed.
Install "MySQL for Visual Studio" v2.0.5 CTP (MySQL for Visual Studio). Note: Install MySQL for Visual Studio before Connector/NET.
Install "Connector/NET" v6.9.10 (Connector/Net). https://i.stack.imgur.com/XOT1I.jpg Note: I tried using Connector/NET v6.8, v6.10 and v8 first, but none of them worked with Visual Studio 2017 and ADO.Net. Here you can find all Connector Versions and Compatibilities with Visual Studio IDEs, but so far this list is inaccurate.
Create new Visual Studio Professional 2017 project.
Download and Install "EntityFramework" v6.2.0 through NuGet, by going to Project Tab/Manage NuGet Packages/Browse -> Entity Framework.
Add references to C:\Program Files (x86)\MySQL\Connector.NET 6.9.10\Assemblies\v4.5\MySql.Data.dll and C:\Program Files (x86)\MySQL\Connector.NET 6.9.10\Assemblies\v4.5\MySql.Data.Entity.EF6.dll; by Right Clicking over References inside Solution Explorer and selecting Add Reference/Browse ->Browse button.
Add MySQL EF6 provider info inside App.config under entity framework providers as follow:

<entityFramework>
       <providers>
         <provider invariantName="MySql.Data.MySqlClient"
              type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6" />
       </providers>
</entityFramework>

Rebuild project by going to Build tab/Rebuild ProjectName.

And that's it. VS2017 is ready to go. Hope this works for everybody, as it did for me today.

References:

edited Jul 10 '21 at 04:12

Napoli

1,389
2
15
26

answered Nov 26 '17 at 16:21

Alfredo Rodriguez

1,223
1
13
12

7

This should be the accepted answer. Well-documented and explains everything in very good detail. Solved my problem. I know this was added after the "accepted answer", but this should now replace it. Thank you! – Boyd P Dec 31 '17 at 21:27
@BoydP except the OP asked about Visual Studio 2013, not 2017 – alex Feb 28 '18 at 23:19
Deserves many upvotes, have been looking for this for so long, the only solution that's very clear an that actually works! – JoaVer May 31 '18 at 20:09
Thank you. I followed your steps and it works like a charm. – Ali Sep 18 '18 at 11:48
You're the main! This was the only solution that worked for me on Visual Studio 2017 Community Edition. (October, 2018) – Ray Goudie Oct 27 '18 at 01:04
Had the same issue with VS 2017. Worked for me as a charm! Thanks a lot. – Nate Nov 25 '18 at 07:44
I can confirm that this worked in VS2015 project. Thanks. – Velja Radenkovic Jan 28 '19 at 13:34
This answer must be marked as correct answer. Worked fine. – Ahmad Badkoubehei Mar 29 '19 at 16:46
1

This absolutely works! I'm very surprised and happy for the moment. Although, it's sad that we as programmers have to get our hands so dirty just to use a feature of software that should already work. I performed Step 6. just a bit differently because I didn't want to browse. I simply typed "MySql" in the search box of the "Reference Manager" form and selected the two required assemblies that way. – Bradley Nov 14 '19 at 23:45
So frustrating! It appears 6.9.10 is the key here as the other definitely don't work (hours of trial and error led me here). – Particleman Nov 27 '20 at 01:43
I used this and My Visual Studio Part was working.. Finally! But for some Reason my MySQL console was crashing. Reinstalled MySQL version 5.7 and that's got fixed. – Jan 06 '21 at 16:56

score 14 · Accepted Answer · edited May 24 '16 at 17:50

14

I solved this issue by following some steps below:

Uninstall MySql.Data.Entities from Nuget by using command below in Package Manager Console: Uninstall-Package MySql.Data.Entities
Add project reference to the latest MySql.Data.Entity.EF6.dll from your MySql connector installation path at: C:\Program Files (x86)\MySQL\MySQL Connector Net 6.9.8\Assemblies\v4.5

edited May 24 '16 at 17:50

Richard Erickson

2,568
8
26
39

answered May 24 '16 at 17:16

Loc Huynh

286
3
3

1

thanks for the tip. worked for me. What I don't get is why have a nuget if its not going to work ... – katesky8 Oct 29 '16 at 01:30
1

I solved the problem by installing same version of MySql.Data and MySql.Data.Entity. – Khizar Iqbal Jun 11 '17 at 12:37
Worked for me, but had to uninstall and reinstall Connector/Net. – pistipanko Jul 10 '17 at 17:47

score 12 · Answer 3 · answered May 07 '16 at 15:57

12

VS 2015 still has this bug. It is caused by version mismatch.

On my system, I had MySQL Connector 6.9.6.
Issuing the command in NuGet Package Manger Console:

Install-Package MySql.Data.Entity

installs version 6.9.8 by default. Your connector must match the actual version of the NuGet Package.
You can download an updated version of the connector from: https://www.mysql.com/products/connector/

Here select the "Ado.net driver for MySQL", and download the corresponding version (in this case 6.9.8). Reopen Visual Studio and now the wizard does not crash. No reboot required.

answered May 07 '16 at 15:57

Lars Meldgård

1,074
10
6

The link to the download if the connector was out of date solved my problem. – AndrewK Jul 28 '16 at 16:14
This solution worked for me with VS2015 and connector 6.9.9. The other suggestions on SO did not work for my setup. up voted. – Yogi Sep 03 '16 at 22:00
had the same issue of the wizard failing but had the correct version. Had to uninstall the connector and reinstall and all good. A repair didnt work. – PodTech.io Jun 30 '17 at 07:27
worked !, here is the link https://dev.mysql.com/downloads/connector/net/6.9.html – frhack Jul 05 '18 at 14:48

score 5 · Answer 4 · answered Dec 04 '18 at 18:32

This is for an ASP.NET MVC application, which does not have an app.config file. I will not recount the failed attempts, but what worked for me was the following:-

With VS not running, download and install "MySQL for Visual Studio 2.0.5" - the latest version at time of writing.
Start VS2017 and uninstall the "MySql.Data.Entity" and "MySql.Data" NuGet packages, if they have been previously installed in VS2017.
Download and install the latest MySql connector/NET using the links above (version 8.0.13 at time of writing).
In your project add references to the "MySql.Data.dll" and "MySql.Data.EntityFramework.dll" dlls as described above by Lopez93, but N.B. the "MySql.Data.Entity.EF6.dll" mentioned did not exist in 8.0.13, only "MySql.Data.EntityFramework.dll".
Now edit the web.config file and make sure that in the section, there is this line

Remove or comment out any other '<provider invariantName="MySql.Data.MySqlClient"...' lines.
Rebuild the project.

Try using the wizard again.

For me this worked.

Good luck!

This solved my issues instantly (using MySql.Data v 8.0.15), check the provider in the `entityFramework` section. This is gold, been working for 2 days now on this, reckon I've tried all the old advice, was about to give up. — Chris Schaller, Apr 02 '19 at 22:27

score 4 · Answer 5 · answered Aug 30 '15 at 07:30

I was able to resolve this problem by performing the following:

Open MySQL Installer and install the latest version of Connector/NET
Uninstall / reinstall the latest version MySQL.Data.* packages with versions that match the version of the newly installed Connector/NET package
Restart Visual Studios
Rebuild solution

score 4 · Answer 6 · answered Jul 27 '16 at 16:56

Taking suggestions about NuGet versioning from others answers. I solved this issue by deleting the .Data and Data.Entitiy.EF6 installed by Nuget.

Then right click on References and browse for:

C:\Program Files (x86)\MySQL\Connector.NET 6.9\Assemblies\v4.5\MySql.Data.dll and C:\Program Files (x86)\MySQL\Connector.NET 6.9\Assemblies\v4.5\MySql.Data.Entity.EF6.dll

I was then able to complete the ADO.Net wizard, with the .edmx models.

score 3 · Answer 7 · answered Mar 16 '15 at 18:22

3

I know the solution.

Nuget installs edge version of MySql.Data.* packages, while you probably have previous version of the connector (In my case packages were v. 6.9.6 and Connector was 6.9.5). This comes to the point where you have version mismatch.

Be aware that if you use Install-Package MySql.Data.Entities in NuGet you will get even older version like 6.8.3, so you have to add the references by yourself and keep an eye on which one you are trying to add to your solution.

answered Mar 16 '15 at 18:22

Lucassith

49
10

I have tried all manner of combinations and this still doesn't work. The system tries and shows all the right dialogs but still creates no model. I've just rolled my own, not as good but it will do as I have no more time to give to this – djack109 Mar 27 '18 at 20:59

score 3 · Answer 8 · answered Aug 07 '19 at 15:30

I ran into this issue upgrading from version 6 of MySql to version 8.0.17.0. I struggled with this for almost two days trying all of the old remedies until I came across this article. If you are using EF6 and version 8.0.? of MySql, according to this post:

MySql.Data.Entity 6.10.7 isn't compatible with MySql.Data 8.0.11.

Oracle renamed the package to MySql.Data.EntityFramework for v8.x. You need to uninstall MySql.Data.Entity and install MySql.Data.EntityFramework.

Once I did this simple step, the data connection started working and the EDMX designer started working as well (although I have to go back to 2017 Visual Studio because the Designer Tools for VS 2019 were not available at the time of this post.)

Hope this newer post helps some of you.

score 2 · Answer 9 · answered Dec 17 '15 at 22:17

I had the same problem using MySQL Connector 6.9.8.0. While all my versions matched, this still failed. I had installed a new version of Visual Studio AFTER the MySQL connector (From 2010 to 2013). For me, the solution was to uninstall the MySQL Connector for NET and then reinstall it (Exact same version). Then restart Visual Studio.

Seems like this is another version of the same problem.

score 1 · Answer 10 · edited Nov 01 '16 at 17:55

1

You can do this solution:

Add a new empty EF model.
In the emdx design rigth click and update the model from database.
choose your database and the model will be generate.

That's work for me :)

edited Nov 01 '16 at 17:55

Simon PA

748
13
26

answered Nov 01 '16 at 16:36

Intissar Ben Yedder

29
5

1

doesn't work for me, neither does the solution below. The wizard comes up but then does nothing – djack109 Mar 27 '18 at 20:41

Lopez93 · Answer 11 · 2018-04-04T11:23:46.113

another thing to try:

--->install the entityframework 6.2.0 via nuget.

--->Verify in your web.config/app.config file that you have the System.Data.SqlServerCe.4.0 provider. if it's not installed, then install it via nuget, the exact same version as the entity framework previously installed (6.2.0 in this case).

--->then add the references: (in this case from the connector/NET version 6.9.10) C:\Program Files (x86)\MySQL\Connector.NET 6.9\Assemblies\v4.5\MySql.Data.dll and C:\Program Files (x86)\MySQL\Connector.NET 6.9\Assemblies\v4.5\MySql.Data.Entity.EF6.dll and rebuild.

--->try adding this provider too: <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6" /> rebuild, again.

--->and finally, try adding the .edmx file with a new connection.

This worked in my case where i installed VS2017 and MySQL in a brand new laptop, and had the same issue.

score 0 · Answer 12 · answered Jul 10 '18 at 20:41

0

I changed my web.config file from:

<provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.EntityFramework, Version=8.0.11.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />

To:

<provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6"></provider>

answered Jul 10 '18 at 20:41

Geovanny López

11
1

This did not work for my Visual Studio 2017 Community project that is experiencing the OP's issue. – Ray Goudie Oct 27 '18 at 00:43

Leo · Answer 13 · 2020-03-30T10:07:05.990

For EntityFramework 5.0

Step 1

Install MySQL Connector/NET version 6.8.4 on https://downloads.mysql.com/archives/c-net/

Install MySQL for Visual Studio on https://dev.mysql.com/downloads/windows/visualstudio/

Step 2

Add Refenreces:

MySql.Data
MySql.Data.Entity.EF5

Step 3

Add codes (at the below) to web.config

 <system.data>
    <DbProviderFactories>
      <remove invariant="MySql.Data.MySqlClient"></remove>
      <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient" description=".Net Framework Data Provider for MySQL" type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, Version=6.8.4.0, Culture=neutral" />
    </DbProviderFactories>
  </system.data>

Can't Create Entity Data Model - using MySql and EF6

13 Answers13

For EntityFramework 5.0

Linked