I am trying to use Entity Framework 5 (first code) for an ASP.NET Web Forms application, I previously had a basic implementation working using a MySQL connection, and I also had a successful desktop application using SQL Server Compact 4.
The problem I am facing is that with EF5 I get an error
The specified store provider cannot be found in the configuration, or is invalid.
which helps very little.
Upgrading to EF6-rc1 gives me a more useful error
The ADO.NET provider with the invariant name "MySql.Data.MySqlClient" is either not registered in the device or application configuration file, or failed to load. See Internal Exception for more details.
At least now I know what a "problem" is.
The problem is that I removed all traces of MySQL from the project, there is no reason why the project should try to load the MySQL provider.
<entityFramework>
<defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlCeConnectionFactory, EntityFramework">
<parameters>
<parameter value="System.Data.SqlServerCe.4.0" />
</parameters>
</defaultConnectionFactory>
<providers>
<provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />
<provider invariantName="System.Data.SqlServerCe.4.0" type="System.Data.Entity.SqlServerCompact.SqlCeProviderServices, EntityFramework.SqlServerCompact" />
</providers>
<connectionStrings>
<add name="im_customerdb" connectionString="Data Source=|DataDirectory|\CustomerData.sdf" providerName="System.Data.SqlServerCe.4.0" />
</connectionStrings>
These are excerpts from my web.config file, please let me know if there are other relevant sections that might indicate a solution.
I performed a text search on each file in the solution for the word MySQL, and there are no links to MySQL. I checked the clean version of the project outside of source control to make sure that I did not skip the file while cleaning up the project assembly files.
Can someone indicate where I should look to determine why EF insists on loading the MySQL provider?
Regards, Anthony
* Edit: * , , , . - ; , , EF MySQL.