How can I use SetInitializer to only update the database? I don't want to drop and recreate it, because I've added only a column:
Database.SetInitializer<myDbContext>( /* Here */ );
-
2You should to add migrations to it!cura– cura2021-05-07 13:35:05 +00:00Commented May 7, 2021 at 13:35
-
1@cura I'm using EF5user1187282– user11872822021-05-07 13:36:31 +00:00Commented May 7, 2021 at 13:36
-
1@user1187282 EF5 can still use migrations.phuzi– phuzi2021-05-07 14:11:56 +00:00Commented May 7, 2021 at 14:11
Add a comment
|
1 Answer
Basically you need to use DropCreateDatabaseIfModelChanges since your model classes (entity classes) have been changed.
You can also create your own custom initializer, if the above do not satisfy your requirements or you want to do some other process that initializes the database using the above initializer.
That should be something like this:
public class YourCustomInitializer : DropCreateDatabaseIfModelChanges<YourDBContext>
{
protected override void Seed(YourDBContext context)
{
// sample data to be written or updated to the DB
}
}
It is worth mentioning, you can simply add your new column to your entity, then use add-migration and update-database commands. You need to run these commands in the PackageManagerConsole.
3 Comments
user1187282
how can i add a column using the DbContext ?
Salah Akbari
@user1187282 Take a look at my updated answer.
phuzi
Thought OP didn't want to drop and create database?!