Set value to null fields after migration

0.00/5 (No votes)

See more:

, +

i have several property in my class that after adding a new property and doing code first migration , the new added fields have null value in Previous records in database , does anybody have any idea about how to set value to them ???

What I have tried:

.....................................................................................

Posted 2-Sep-18 7:16am

Member 13933681

Add a Solution

Comments

CHill60 2-Sep-18 13:23pm

Write a sql query to update them to whatever you want the default value to be.

Member 13933681 3-Sep-18 2:49am

they're not default values

CHill60 3-Sep-18 4:10am

Then write a sql query to update the older records to the values you want them to be. Run that query via Sql Server Management Studio (or whatever IDE is relevent to whatever database you are using).
Personally, I strongly dislike Code First programming - in my experience, the database always ends up in a right state.

Sinisa Hajnal 5-Sep-18 2:28am

I strongly agree with this CHill60. Write your database first and then code over that. Database is made to work with data, code is for logic and presentation.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Last 24hrs

This month

Pete O'Hanlon	140
Dave Kreskowiak	85
OriginalGriff	85
Andre Oosthuizen	45
Richard MacCutchan	20

Pete O'Hanlon	1,790
OriginalGriff	1,315
Graeme_Grant	810
Richard Deeming	743
Dave Kreskowiak	634

Set value to null fields after migration

Add your solution here

Preview 0

Set value to null fields after migration

Add your solution here

Preview 0

Existing Members

...or Join us