CODEWITHSUNDEEP
c#entity-frameworkasp.net-web-api
user1345260
user1345260

Reputation: 2249

No connection string named could be found in the application config file

I'm using EF and generated .EDMX from it but then I only wanted it to be used for automated generation of Class Files.

I then used the Class Files to create a Entity Model and then created a DB Context and then Repository. I'm calling a WebApi (which is in a separate project but same solution) to access the repository to GET data. While I run the WebApi, I'm getting the error,

{"No connection string named 'DBEntities' could be found in the application config file."}

But within my DAL, I have a webConfig and that has the following entry so I'm not quite sure what has gone wrong,

add name="DBEntities" connectionString="metadata=res://*/Models.DBModel.csdl|res://*/Models.DBModel.ssdl|res://*/Models.DBModel.msl;provider=System.Data.SqlClient;provider connection string="data source=MY-PC;initial catalog=DB;integrated security=True;multipleactiveresultsets=True;application name=EntityFramework"" providerName="System.Data.EntityClient"

Upvotes: 20

Views: 71308

Answers (10)

Plate
Plate

Reputation: 81

Double-check your /bin/ folder to make sure your built app's config (e.g. Foo.exe.config) has the connection string you're expecting.

If it's missing there, but present in your App.config, then in Solution Explorer, check the Properties of that App.config file. Make sure "Copy to Output Directory" is not "Do not copy". For example, try "Copy always". Then rebuild.

This might have accidentally been set to "Do not copy" if you copied the App.config file from a different project.

Upvotes: 0

Banshi Gurjar
Banshi Gurjar

Reputation: 44

If none of the above fixes the issue, then probably you are doing the mistake I did, here was my case: I have multiple projects in my solution and the Startup project was different than the one having the entity framework, switching project from the package manager console seems like a buggy thing especially in entity framework commands, so here what I did:

  1. Set your webapi(Or the project has the entity framework) as a startup project.
  2. Rebuild the solution and try again.
  3. Run the entity framework command again.

If the above doesn't work then try to close the solution and try from Step 2, this should fix it.

Upvotes: 1

IMK
IMK

Reputation: 718

Setting the project as Startup project worked for me

Upvotes: 3

noelicus
noelicus

Reputation: 15055

It's dumb, but I had this error that was fixed by a Rebuild All !!
Might as well have turned it off and on again....

Upvotes: 1

dunwan
dunwan

Reputation: 1607

In the DBContext file, remove

public RaficaDB()
: base("name=DefaultConnection"){}

to

public RaficaDB()
: base("DefaultConnection"){}

EF 4.3, EF 5 and EF 6 do not like the connection string being called name=xxxxx

Answer found here -> No connection string named 'MyApplicationEntities' could be found in the application config file

Upvotes: 55

Praveen Thangaraja
Praveen Thangaraja

Reputation: 111

Copy and paste the connectionstring to your WEBAPI Project web.config file will solve the issue.

Upvotes: 1

Ayub
Ayub

Reputation: 2375

The easiest solution:

Remove current edmx file and related connection string in app.config and add Edmx item with same name as previous again.

this worked for me.

Upvotes: 0

R3verse
R3verse

Reputation: 79

I found that this worked:

1) Check if you have several "App.config" files. 2) Check if has a wrong name than the connection string it has to use. 3) Save the project and run the program

It should work now.

Upvotes: 2

Raishul
Raishul

Reputation: 146

Insert following section in the configuration section of the .config file of the same project where your .edmx file is under.

You may also create different connection string for different environment in the .config file of the main project and pass any of the connection string as parameter of the constructor of the DBContext.

<connectionStrings>
  
<add name="DBEntities" connectionString="metadata=res://*/Models.DBModel.csdl|res://*/Models.DBModel.ssdl|res://*/Models.DBModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=MY-PC;initial catalog=DB;integrated security=True;multipleactiveresultsets=True;application name=EntityFramework&quot;" providerName="System.Data.EntityClient" />

</connectionStrings>

Upvotes: 4

Paolo Costa
Paolo Costa

Reputation: 1989

You say "within my DAL, I have a webConfig". I guess the connection string is in the configuration file of a referenced class library, but not in the main configuration file you have in your entry project (a web api project, I guess looking at the tags).

If so, just copy the connection string in the entry project configuration file.

Upvotes: 17

Related Questions