Finalize EF Migration strategy about fanray HOT 1 CLOSED

I have dropped support for sqlite, I can concentrate on development more, don't have to switch between sql server and sqlite to test both.

I have come back to a single dbcontext that controls every entity in the entire solution, but this time I used reflection to find and load these entities, mappings dynamically.

To add a migration, open Package Manager

1. select "src\Fan" as the Default project
   Add-Migration FanSchemaV1
   This will add a new folder "Fan/Migrations" with a migration named FanSchemaV1

2. ctrl + f5, the site is up running with db automatically created

3. Add a property to Post class, say public int SortOrder { get; set; }
   Add-Migration FanSchemaV1_Add_SortOrder
   This will add a new migration.

4. ctrl + f5, site is up running with Post table have new column SortOrder added automatically in db

Any changes to db can now be down with Add-Migration and just run the app. If I want to get the sql script running behind each migration, I can run Script-Migration [-Idempotent] to review.

from fanray.