Home → Support →

SOLVED: MySQL Provider with Entity Framework Problem

• Edit

rkotecha

25 Feb, 2012 11:40 AM

Have to be brief here, but if you're getting exceptions like:
ArgumentException: The specified store provider cannot be found in the configuration, or is not valid.
ArgumentException: Unable to find the requested .Net Framework Data Provider. It may not be installed.

You have to do the following:

1. Ensure MySQL.Data.dll, MySQL.Web.dll, MySQL.Data.Entity.dll, and System.Data.Entity.dll are all being copied local (right click on assembly and ensure Copy Local is set to true)
   I also added the following locally as I tried to debug this problem but it was probably unnecessary
   System.Data.dll [probably optional]
   System.Data.Entity.Design [probably optional]

2. And here's the step you wont read about in many places on google or on AppHarbor!
   Add the following to your web.config file:

     <system.data>
         <DbProviderFactories>
           <clear />
           <add name="MySQL Data Provider" invariant="MySql.Data.MySqlClient"
           description=".Net Framework Data Provider for MySQL"
           type="MySql.Data.MySqlClient.MySqlClientFactory, MySql.Data, 
           Version=6.4.4.0, Culture=neutral, PublicKeyToken=c5687fc88969c44d" />
         </DbProviderFactories>
       </system.data>
   

1. Support Staff 1 Posted by friism on 25 Feb, 2012 06:16 PM

   

   Awesome, thanks for sharing!

   Michael

   • Edit

2. 2 Posted by Thong on 18 Sep, 2012 01:33 AM

   

   Thanks, This helps me alot after hours in Google :(. You have done it.

   • Edit

3. friism closed this discussion on 18 Sep, 2012 01:34 AM.