How to delete and recreate from scratch an existing EF Code First database

by

If I’m understanding it right…

If you want to start clean:

1) Manually delete your DB – wherever it is (I’m assuming you have your connection sorted), or empty it, but easier/safer is to delete it all together – as there is system __MigrationHistory table – you need that removed too.

2) Remove all migration files – which are under Migrations – and named like numbers etc. – remove them all,

3) Rebuild your project containing migrations (and the rest) – and make sure your project is set up (configuration) to build automatically (that sometimes may cause problems – but not likely for you),

4) Run Add-Migration Initial again – then Update-Database

More Related Contents:

  1. EntityType ‘IdentityUserLogin’ has no key defined. Define the key for this EntityType
  2. EntityFramework code-first custom connection string and migrations
  3. Multiple DB Contexts in the Same DB and Application in EF 6 and Code First Migrations
  4. Using Entity Framework (code first) migrations in production
  5. Debug code-first Entity Framework migration codes
  6. EF Code First – 1-to-1 Optional Relationship
  7. Mapping Database Views to EF 5.0 Code First w/Migrations
  8. Using mvc-mini-profiler database profiling with Entity Framework Code First
  9. Composite Key with EF 4.1 Code First
  10. EF5 Code First – Changing A Column Type With Migrations
  11. How do I define a database view using Entity Framework 4 Code-First?
  12. There is already an object named in the database
  13. How I can read EF DbContext metadata programmatically?
  14. Possible to default DateTime field to GETDATE() with Entity Framework Migrations?
  15. Entity Framework Code First Using Guid as Identity with another Identity Column
  16. Map Many to Many relationship without navigation property
  17. Entity Framework: One Database, Multiple DbContexts. Is this a bad idea? [closed]
  18. Unique key with EF code first
  19. What effect(s) can the virtual keyword have in Entity Framework 4.1 POCO Code First?
  20. How Should I Declare Foreign Key Relationships Using Code First Entity Framework (4.1) in MVC3?
  21. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  22. EF Code First – how to set identity seed?
  23. mapping private property entity framework code first [duplicate]
  24. EF4 Code First: how to add a relationship without adding a navigation property
  25. How to create index in Entity Framework 6.2 with fluent configuration
  26. Enums with EF code-first – standard method to seeding DB and then using?
  27. Entity Framework: Duplicate Records in Many-to-Many relationship
  28. EF Code First foreign key without navigation property
  29. AutomaticMigrationsEnabled false or true?
  30. LINQ to Entities does not recognize the method ‘System.String ToString()’ method in MVC 4

Leave a Comment