update-database: “A network-related or instance-specific error occurred while establishing a connection to SQL Server”

I finally found out. I have a website project and my API in my solution. The problem was that the website was set as startup project. So that entity framework searched the connection string in the website’s web.config and not in the api’s web.config. Changing the startup project to my API solved the problem.

If you want to have the website project as startup project. Just copy the connection string into the websides web.config.

Nevertheless thanks for everyones help.

Related Contents:

  1. EF migration for changing data type of columns
  2. There is already an open DataReader associated with this Command which must be closed first
  3. MetadataException: Unable to load the specified metadata resource
  4. How to get the connection String from a database
  5. What is the purpose of the “Prefer 32-bit” setting in Visual Studio and how does it actually work?
  6. The cast to value type ‘Int32’ failed because the materialized value is null
  7. What is the difference between Debug and Release in Visual Studio?
  8. Entity Framework async operation takes ten times as long to complete
  9. What is the purpose of the vshost.exe file?
  10. Why is “Set as Startup” option stored in the suo file and not the sln file?
  11. Pass connection string to code-first DbContext
  12. Add Items to Columns in a WPF ListView
  13. The type of one of the expressions in the join clause is incorrect in Entity Framework
  14. Debugging automatic properties
  15. .NET Core 2.2 Can’t be Selected In Visual Studio Build Framework
  16. Is it possible to capture a 0..1 to 0..1 relationship in Entity Framework?
  17. A specified Include path is not valid. The EntityType does not declare a navigation property with the name *
  18. Does Entity Framework Code First support stored procedures?
  19. Why is inserting entities in EF 4.1 so slow compared to ObjectContext?
  20. Entity Framework Code Only error: the model backing the context has changed since the database was created
  21. An object with the same key already exists in the ObjectStateManager. The ObjectStateManager cannot track multiple objects with the same key
  22. Insert data using Entity Framework model
  23. Why does Visual Studio Type a Newly Minted Array as Nullable?
  24. How can I embed an application manifest into an application using VS2008?
  25. Entity Framework 6: audit/track changes
  26. How to Bulk Update records in Entity Framework?
  27. Determine assembly version during a post-build event
  28. linq to entities doesn’t recognize a method
  29. Self referencing loop detected – Getting back data from WebApi to the browser
  30. Entity Framework Filter “Expression”
  31. Dynamic MySQL database connection for Entity Framework 6
  32. How to declare one to one relationship using Entity Framework 4 Code First (POCO)
  33. DbSet.Attach(entity) vs DbContext.Entry(entity).State = EntityState.Modified
  34. ‘No database provider has been configured for this DbContext’ on SignInManager.PasswordSignInAsync
  35. How does Entity Framework work with recursive hierarchies? Include() seems not to work with it
  36. “The LINQ expression node type ‘Invoke’ is not supported in LINQ to Entities” – stumped!
  37. Mapping Database Views to EF 5.0 Code First w/Migrations
  38. Unable to copy a file from obj\Debug to bin\Debug
  39. Generate C# project using CMake
  40. Include with FromSqlRaw and stored procedure in EF Core 3.1
  41. Is Deferred Execution in Asp.net MVC View a very bad thing?
  42. Eager , Lazy and explicit loading in EF6
  43. Why is Asp.Net Identity IdentityDbContext a Black-Box?
  44. Can EF automatically delete data that is orphaned, where the parent is not deleted?
  45. c# Visual Studio …adding references programmatically
  46. Should I compile release builds with debug info as “full” or “pdb-only”?
  47. The name ‘ViewBag’ does not exist in the current context – Visual Studio 2015
  48. How to do an “in” query in entity framework?
  49. Why Entity Framework performs faster than Dapper in direct select statement [closed]
  50. How to Specify Primary Key Name in EF-Code-First

Leave a Comment