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
Post a Comment