Solution to Error 175 The specified store provider cannot be found in the configuration or is not valid
When building a .NET solution that uses the Entity Framework (EF) the following error message is displayed: “Error 175: The specified store provider cannot be found in the configuration, or is not valid.” and the build fails.
The assembly of the provider being used by the Entity Framework cannot be found, that is, it cannot be found in the solution’s references, probe path’s or GAC. The provider is defined in the connection string to the data, e.g. for MySql it is “provider=MySql.Data.MySqlClient” so in this case the error is referring to the assemblies of the the My SQL Connector
Download/install the relevant assemblies that relate to the provider being used and add them as a reference to your solution if it is not automatically inserted into the GAC on installation.
(For the MySQL provider download and install the latest .NET Connector found here: http://dev.mysql.com/downloads/connector/net/)