Sunday, August 24, 2014

No Entity Framework provider found for 'MySql.Data.MySqlClient' ADO.NET provider. Make sure the provider is registered in the 'entityFramework' section of the application config file.



Upgrading to EntityFramework6 has been a nightmare. There has been almost no useful documentation for how to get everything up and running with MySql. I downloaded the connectors, the MySql plugin for Visual Studio, and Entity Framework 6.1.1. Still, I kept receiving this error:

"No Entity Framework provider found for 'MySql.Data.MySqlClient' ADO.NET provider. Make sure the provider is registered in the 'entityFramework' section of the application config file."

The problem here was that I had two different projects in my solution file. One was the source code, one was tests. The test project was not importing the same dependencies for MySql.Data that the source code had. The solution I did was the following:


  1. Right click on the Solution (top level in the solution explorer)
  2. Manage Nuget packages for solution
  3. Go to Installed tab
  4. For all of the EntityFramework related packages (MySql.Data, MySql.Data.Entities, MySql.ConnectorNET.Entity and MySql.ConnectorNET.Data), select them then select the "Manage" button.
  5. Enable each package for all projects.

Tuesday, August 19, 2014

EDMX Fix - An exception of type 'System.ArgumentException' occurred while attempting to update the database."



If you are connected to a MySQL database and you're trying to re-populate an edmx file from the database tables and you receive this error, it means that you are missing the following plugin:

http://dev.mysql.com/downloads/windows/visualstudio/

You should already have the MySQL Connector plugin for VS2013 if you reach this point. That's all you need to get connected and get updated.