Cannot attach the file *.mdf as database

by

I think that for SQL Server Local Db you shouldn’t use the Initial Catalog property.
I suggest to use:

<add name="DefaultConnection" 
     connectionString="Data Source=(LocalDb)\v11.0;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\OdeToFoodDb.mdf" 
     providerName="System.Data.SqlClient" />

I think that local db doesn’t support multiple database on the same mdf file so specify an initial catalog is not supported (or not well supported and I have some strange errors).

More Related Contents:

  1. Entity Framework and Connection Pooling
  2. Fake DbContext of Entity Framework 4.1 to Test
  3. how to use views in code first entity framework [closed]
  4. MVC4 HTTP Error 403.14 – Forbidden
  5. Windows update caused MVC3 and MVC4 stop working
  6. Can’t find ADO.net Entity Data Model template in VS2017
  7. Where to run a duplicate check for an entity
  8. The model backing the ‘ApplicationDbContext’ context has changed since the database was created
  9. Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths – why?
  10. LINQ to Entities does not recognize the method
  11. store image in database or in a system file? [closed]
  12. Undo changes in entity framework entities
  13. ASP.NET MVC: Is Controller created for every request?
  14. Filter/Search using Multiple Fields – ASP.NET MVC
  15. Extracting files from an Attachment field in an Access database
  16. EF LINQ include multiple and nested entities
  17. Batching DB commands in Entity Framework 4.0
  18. Enable Migrations with Context in Separate Assembly?
  19. Connection string using Windows Authentication
  20. How to cancel a long-running Database operation?
  21. .NET MVC Call method on different controller
  22. instance of entity type cannot be tracked because another instance with same key value is tracked [closed]
  23. Changing the type of an (Entity Framework) entity that is part of an inheritance hierarchy
  24. Entity Framework 4 Single() vs First() vs FirstOrDefault()
  25. Accessing post or get parameters in custom authorization MVC4 Web Api
  26. How to store images using Entity Framework Code First CTP 5?
  27. All requests to ASP.NET Web API return 404 error
  28. ASP.NET MVC on IIS6
  29. Validate data using DataAnnotations with WPF & Entity Framework?
  30. Getting exact error type in from DbValidationException

Leave a Comment