MySQL Server 5.7 with Visual Studio 2017 and EntityFramework Install Guide

MySQL5.7-EntityFramework-Guide.md

Installing MySQL 5.7 Server with EntityFramework in Visual Studio 2017

• Install MySQL Server 5.7.25

• Install Complete MySQL Connector.Net 6.9.10

• 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.

• Right Click References > Add > Click Assemblies or Extensions > Search MySQL > Tick all

• 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="MySql.Data.Entity.MySqlConnectionFactory, MySql.Data.Entity.EF6" />
    <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>