Question: I have Reporting\_officers Table.structure of table is below

```
R_id    User_id Manager_id  Managre2_id
1        4       3        3
2        3       2        2
3        5       3        2

```

now i want update user\_id 3 to 6 in this table, then it should reflect to manager\_id and manger2\_id which have 3 
like below

```
R_id    User_id   Manager_id  Managre2_id
 1          4         6           6
 2          6         2           2
 3          5         6           2

```

Answer: 
Please try 

```
AddColumn("dbo.Props", "Prop1", c => c.Double());   
AddColumn("dbo.Props", "Prop2", c => c.Int());
Sql("UPDATE dbo.Props SET Prop1 = 0, Prop2 = 0 WHERE Discriminator = 'MyProp'");

```

The idea is to update with not null value the old values from DB table with Discriminator "MyProp"
Ok... Use like below

```
AddColumn("dbo.Props", "Prop2", c => c.Int(nullable: false, defaultValue: 0));

```

set nullable:false in your code