20

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"
crthompson
  • 15,653
  • 6
  • 58
  • 80
user1345260
  • 2,151
  • 12
  • 33
  • 42

9 Answers9

54

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

Community
  • 1
  • 1
dunwan
  • 1,577
  • 2
  • 16
  • 14
  • 1
    If you supply `name=xxx` to the constructor, it will look for that specific connection string and throw an error if not set. If you don't specify `name=xxx`, the localdb/sqlexpress will attempt to create it. https://msdn.microsoft.com/en-us/library/jj592674(v=vs.113).aspx – murraybiscuit Jul 11 '17 at 19:46
17

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.

Paolo Costa
  • 1,989
  • 1
  • 12
  • 15
  • I did add the connection string to webapi and I now get the following, {"Schema specified is not valid. Errors: \r\nThe mapping of CLR type to EDM type is ambiguous because multiple CLR types match the EDM type Client} – user1345260 May 06 '15 at 18:52
  • Does this help? http://stackoverflow.com/questions/14927391/the-mapping-of-clr-type-to-edm-type-is-ambiguous-with-ef-6-5 – Paolo Costa May 06 '15 at 18:59
4

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>
Raishul
  • 146
  • 2
  • 6
3

Setting the project as Startup project worked for me

IMK
  • 654
  • 9
  • 15
  • 1
    Likewise; I was doing a code migeration from the Package Manager Console and it couldn't find my connection string in the app.config BECAUSE it was reading the app.config of a different project. – Otis Apr 23 '20 at 19:37
2

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.

R3verse
  • 71
  • 2
  • 8
1

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

Praveen Thangaraja
  • 111
  • 1
  • 1
1

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....

noelicus
  • 14,468
  • 3
  • 92
  • 111
1

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.

Banshi Gurjar
  • 44
  • 1
  • 9
0

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.

Ayub
  • 2,345
  • 27
  • 29