Update data in existing column with EF Core Migration

Question

My table in SQL has two fields: Id and Status. It looks something like this

ID | Status

1 | "Status1"

2 | "Status2"

I should make a migration that will change those status values into those that I want? How can I achieve this?

You can use a plain SQL script to update the data values. It can be added to a migration file. Is that what you want to know? — David Donari, Feb 19 '20 at 12:54
Does this answer your question? [Can we run SQL script using code first migrations?](https://stackoverflow.com/questions/32125937/can-we-run-sql-script-using-code-first-migrations) — David Donari, Feb 19 '20 at 12:58

score 14 · Accepted Answer · answered Feb 20 '20 at 07:27

I should make a migration that will change those status values into those that I want?

Try add SQL statements into Up method of the generated migration file manually like below

protected override void Up(MigrationBuilder migrationBuilder)
{
        migrationBuilder.Sql("UPDATE A SET AName = 'Jhon' WHERE Id=3");
}

For updating multiple records , you could refer to the following code

protected override void Up(MigrationBuilder migrationBuilder)
{
        migrationBuilder.Sql(
           "UPDATE A SET AName = CASE Id " +
                   "WHEN 1 THEN 'Shariy' " +
                   "WHEN 2 THEN 'Mary'" +
                   "ELSE AName END " +
                   "WHERE Id IN(1,2)");
}

Update data in existing column with EF Core Migration

1 Answers1