This post thows up a glimpse on the basic commads syntax and usage serving as a quick reference when ever you are struck out for pretty basic thing. Let’s get started.

Want to enable Migrations in your Project ?
Enable-Migrations
This command add Migrations Folder to our project which has two files
1.The Configuration class
2.An InitialCreate migration

Changed something in datamodel and you want EF to scaffold chages for you?
Add-Migration  

Want to reflect the changes  in the Database?
Update-Database
Update-Database-verbose

-verbose ,To see the sql behind the update.

Downgrade the database changes?
Update-Database-TargetMigration:
In TargetMigration, specify the name of the migration upto which you wish to downgrade the changes.

Downgrades the changes to the Initial Database state.
Update-Database-Targetmigration:$InitialDatabase

Update-Database-Script-SourceMigration:$InitialDatabase-TargetMigration: writes the migration to an sql file rather than migrations being applied.SourceMigration and TargetMigrations vary in between the migrations present.Migration file Name is prefixed with timestamp to help ordering of migrations

Multiple Models Sharing the  _MigrationsHistory Table

Starting with EF6, the Configuration class includes a ContextKey property. This acts as a unique identifier for each Code First model. A corresponding column in the __MigrationsHistory table allows entries from multiple models to share the table. By default, this property is set to the fully qualified name of your context.

Advertisements