Solve: Your project references the latest version of Entity Framework (for MySQL) in Visual Studio 2013

浏览数：520 / 时间：2015年06月12日

The error message while trying to create a ADO.net Entity Data Model ( Entity Framework 6 ) for MySql Database in Microsoft Visual Studio 2013

"Your project references the latest version of Entity Framework; however, an Entity Framework database provider compatible with this version could not be found for your data connection. if you have already installed a have already installed a comptible provider, ensure you have rebuilt your project before performing this action. Otherwise, exit this wizard, install a compatible provider, and rebuid your project before performing this action."

Solution:

1. Before start solution steps, check the following Pre-requirements:

You completely Install mysql-installer-community-5.7.3.0-m13.msi or Install both of mysql-visualstudio-plugin-1.1.1.msi and mysql-connector-net-6.8.3.msi.

2. Registering EF providers

Remove the default entityFramework tag in App.config or Web.config

  <entityFramework>
    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">
      <parameters>
        <parameter value="v11.0" />
      </parameters>
    </defaultConnectionFactory>
    <providers>
      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
    </providers>
  </entityFramework>

Add the following entityFramework tag:

  <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" />
    </providers>
  </entityFramework>

3. Adding The following References to your project or check it versions:

MySql.Data.dll
MySql.Data.Entity.EF6.dll
MySql.Web.dll

They should reside the following folders:

C:\Program Files\MySQL\MySQL Connector Net 6.8.3\Assemblies\v4.5 (32bit windows)
C:\Program Files (x86)\MySQL\MySQL Connector Net 6.8.3\Assemblies\v4.5 (64bit windows)