EF Migrations: Can't add DateTime column -


i'm using asp.net 4 ef 4.3.1 code first migrations.

i have existing model class. i've added property it:

public datetime lastupdated { get; set; } 

when run update-database -force -verbose get:

alter table [mytable] add [lastupdated] [datetime] not null default '0001-01-01t00:00:00.000'
system.data.sqlclient.sqlexception (0x80131904): conversion of varchar data type datetime data type resulted in out-of-range value.
statement has been terminated.

i'm going guess relates implied default value being used in generated sql - appear complaining varchar used initialize things data lost.

the answer problem of not being able add non-null datetime column same problem of getting 2 default values specified datetime column: ef 4.3.1 migration exception - altercolumn defaultvaluesql creates same default constraint name different tables

that is, it's been broken long time, , can workaround migrating nullable:

public datetime? lastupdated { get; set; }  pm> update-database 

then migrate again not null intended:

public datetime lastupdated { get; set; }  pm> update-database 

Comments