The connection string 'MyConnection' in the application's configuration file does not contain the required providerName attribute."

entity-framework ef-code-first connection-string
Hodaya Shalom picture Hodaya Shalom · Feb 25, 2013 · Viewed 58.5k times · Source

I use Entity Framework Code First,

My connection string is in a configuration file:

<connectionStrings>
    <clear/>
    <add name="ApplicationServices" connectionString="Data Source=PC-X;Initial Catalog=MYdb;Integrated Security=True"/>
  </connectionStrings>

When I try to access the data (something that should create the DB) is falling with the following error:

The connection string 'ApplicationServices' in the application's configuration file does not contain the required providerName attribute."

What am I missing?

Answer

Corey Adler picture Corey Adler · Feb 25, 2013

You're missing the following piece of code after the connectionString attribute (assuming that you're using SQL):

providerName="System.Data.SqlClient"

Related questions

EntityFramework code-first custom connection string and migrations

When I create a context with a default connection string (as read from the app.config) the database is created and the migrations work - basically everything is in order. Whereas when the connection string is created programatically (using SqlConnectionStringBuilder): …

Read More
Entity Framework Code First and Connection String Issue

I am getting this error when using Entity Framework 4.1 code first. I can not find any sources of what exactly to use. Unable to load the specified metadata resource. <add name="DataContext" connectionString="metadata=res://*/GrassrootsHoopsDataContext.csdl|res://*/GrassrootsHoopsDataContext.…

Read More
unable to retrieve metadata for unrecognized element providers

I get a message error whenever I try to add a controller with Entity framework template but I keep getting a error message unable to retrieve metadata for 'path' unrecognized element providers. (C:\Users\user\appdata\local\Temp-mp6124.tmp line 78) …

Read More