Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Save pishangujeniya/41a051572a471fa0311a8f4f6d0c5332 to your computer and use it in GitHub Desktop.
Save pishangujeniya/41a051572a471fa0311a8f4f6d0c5332 to your computer and use it in GitHub Desktop.
MySQL Server 8.0 with Visual Studio 2017 and EntityFramework Install Guide

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

@eyeveye
Copy link

eyeveye commented Jul 12, 2021

Proven is working! Thanks!

@eyeveye
Copy link

eyeveye commented May 29, 2022

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment