MySQL Server 8.0 with Visual Studio 2017 and EntityFramework Install Guide

MySQL-8-Visual-Studio-2017-EntityFramework-Guide.md

Installing MySQL 8.0 Server with EntityFramework in Visual Studio 2017

• Install MySQL Server 8.0

• Install Complete MySQL Connector.Net x86 8.0.16

• Install Complete MySQL Visual Studio Plugin 1.2.8

• If after installing MySQL Visual Studio Plugin it shows warning that failed to execute comamnd devenv /updateconfiguration, then manually execute that command in Developer Command Prompt for Visual Studio 20xx with run as administrator.

• Run this command Install-Package EntityFramework -Version 6.4.0 in Visual Studio Nuget package manager console

• Run this command Install-Package MySql.Data -Version 8.0.16 in Visual Studio Nuget package manager console

• Run this command Install-Package MySql.Data.EntityFramework -Version 8.0.16 in Visual Studio Nuget package manager console

• Comment the following kind of similar code from Web.config

<entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework"/>
    <providers>
      <provider invariantName="MySql.Data.MySqlClient"
          type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.Entity.EF6"/>
      <provider invariantName="System.Data.SqlClient"
          type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer"/>
    </providers>
  </entityFramework>

• Add this lines if its not automatically added after </runtime> tag in Web.config and rebuild solution

<entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework" />
    <providers>
      <provider invariantName="MySql.Data.MySqlClient" type="MySql.Data.MySqlClient.MySqlProviderServices, MySql.Data.EntityFramework, Version=8.0.16.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
  </entityFramework>

• This process is tested and working for .Net Framework 4.7.2

Helpers

• Requirements
• Guide
• Guide Fix

Thank you for this. I've spent two days installing different packages, trying different app.config changes and nothing worked. I didn't follow your instructions to the letter but you got me there anyway. Thanks for clear instructions. The key element for me seemed to be removing the mention of EF6 that was placed by God knows what. After that I got rid of the trailing and the whitespace as a whole. That fixed my "wrong version" problem. Lastly I noticed I was on a different version (8.0.17 which is most current as of time of this writing) so I changed that in the app.config. This fixed my "wizard disappears without seeming to do anything" problem.

Wanted to leave this note here for anyone who's searching for an answer. Your post was great!

Thanks for your very detailed steps. This got me beyond the original error "Your project references the latest version of Entity Framework; however, an Entity Framework database provider compatible". However, now I get the "wizard disappears without seeming to do anything" issue. I have spent over 2 days on this and I am losing the will to live. Any clues anyone. Thanks in advance,

For me it was an XML error that wasn't caught in the error list. In the connection strings scroll all the way to the right and make sure everything tag is opened and closed properly. You might see a blue squiggle indicating formatting error.

Yeah, I did notice the blue squiggle. I corrected that but still the wizard disappears. Driving me crazy.

For anyone still having this issue, follow this to the letter but take the newest versions for all of the NuGet packages except the Google Protobuf, use the version listed above (I used Mysql.Data v8.0.19, Mysql.Data.Entity v6.10.9, Mysql.Data.EntityFramework v8.0.19). Then update the XML tag for "Version=8.0.15.0" to the version you used This worked for me after I experienced the different status messages and wizard crashes.

Proven is working! Thanks!

Trying to update all the latest package, however the below combination is not working. It will not allow you to add the Entity Model:
EntityFramework 6.4.4
MySql.Data 8.0.29
MySql.Data.EntityFramework 8.0.29
MYSQL Connector/NET 8.0.29

This combination works:
EntityFramework 6.4.4
MySql.Data 8.0.28
MySql.Data.EntityFramework 8.0.28
MYSQL Connector/NET 8.0.28