The specified named connection is either not found in the configuration, not intended to be used with the EntityClient provider, or not valid

by

I suspect that your issue is coming from the fact that you have more than one project in your solution and the one that contains your entity framework stuff including edmx files is NOT the solutions’s startup project. In this case even if the connection string exists in the EF app.config project, still CLR cannot find it at runtime. For example, if you have a web site and a EF project in your solution, you need to copy the connection string from the EF project’s app.config to your website’s web.config. Basically, any connection string data should exist in the config file of the project that the .Net threads initiated from by CLR (i.e. your startup project).
If this is not your case, then just open your edmx file, right click on its surface, select properties and copy the connection string and paste it into your app.config Connection String section. This way you can make sure that you are having the correct one in your config.

EDIT:

As you can see here on
Documenation on ObjectContext Constructor, the first parameter is the connectionstring name which is code generated at the time you create your EDM. If, somehow, the name of your connectionstring name happens to be changed, all you need to do is right clicking on your model and selecting “Update Model From Database…” then follow the wizard to update your confing and designer to reflect this change.

More Related Contents:

  1. What’s the difference(s) between .ToList(), .AsEnumerable(), AsQueryable()?
  2. Disable lazy loading by default in Entity Framework 4
  3. ADO.NET DbContext Generator vs. ADO.NET Poco Entity Generator (ObjectContext)
  4. How to include a child object’s child object in Entity Framework 5
  5. Entity Framework 4 / POCO – Where to start? [closed]
  6. Asp.Net Web API Error: The ‘ObjectContent`1’ type failed to serialize the response body for content type ‘application/xml; charset=utf-8’
  7. Unique keys in Entity Framework 4
  8. Entity Framework 4 selective lazy loading properties
  9. Upgrade EF 4 EDMX to EF 6
  10. Querying objects after AddObject before SaveChanges?
  11. EF Migrations: Rollback last applied migration?
  12. EF Code First giving me error Cannot insert explicit value for identity column in table ‘People’ when IDENTITY_INSERT is set to OFF. [duplicate]
  13. Using Entity Framework with an SQL Compact Private Installation
  14. Map two different entities to the same table?
  15. How to use Entity Framework to map results of a stored procedure to entity with differently named parameters
  16. AutomaticMigrationsEnabled false or true?
  17. Compose queries across Entity Data Models
  18. Changing Inherited Types in Entity Framework
  19. Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths – why?
  20. Entity Framework Join 3 Tables
  21. How do I delete multiple rows in Entity Framework (without foreach)
  22. Batch update/delete EF5
  23. how to update an entity in Entity Framework 4 .NET
  24. The result of a query cannot be enumerated more than once
  25. Entity Framework – Add Navigation Property Manually
  26. Entity Framework 4.1 default eager loading
  27. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  28. Is it possible to prevent EntityFramework 4 from overwriting customized properties?
  29. Using the Entry().CurrentValues.SetValues() is not updating collections
  30. An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key

Leave a Comment