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

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