The specified store provider cannot be found in the configuration, or is not valid.

edited June 2012
I get this error when i try to test my EF connection:

MetadataException: Schema specified is not valid. Errors:
(0,0) : error 0175: The specified store provider cannot be found in the configuration, or is not valid.

I have my connection to use SQL Server provider and i can see and select my database from the connection setup window in LINQPad, on my config file i have a connection string like this:

<connectionStrings>
<add name="DBContext" connectionString="metadata=res://*/DBContext.csdl|res://*/DBContext.ssdl|res://*/DBContext.msl;provider=System.Data.SqlClient;provider connection string="data source=(local)\sql2008;initial catalog=DBDev;integrated security=True;multipleactiveresultsets=True;App=EntityFramework"" providerName="System.Data.EntityClient"/>
</connectionStrings>

This config file works correctly when i use it in my application but not in LINQPad. Reading through some of msdn and stackoverflow posts i found that it may not be finding the System.Data.SqlClient provider but i do have System.Data in my GAC should it be finding it from there?

Thank in advance!
Sign In or Register to comment.