Re: Entity framework with mysql

[Dave de Moel]

I don't know if you already solved your problem, but if not, there are a couple of things you can still try.

1. I see something in your connection string that can cause issues that in general occur when you publish the website online. Change the $quot; with ' in the connection string. See the following example:

connection string='server=localhost;user id=root;password=Password;persist security info=True;database=classicmodels'"

2. I also see you have commented the following line in the web.config:
<!--<remove invariant="MySql.Data.MySqlClient" />-->
Uncomment it.

3. You need to use the following providerName: providerName="System.Data.EntityClient"

I assume you are using a service layer to handle all queries, and thus you get the not exactly clear error: The specified store provider cannot be found in the configuration, or is not valid.

I have had the same problem, and the above things helped for me.