ORA-22859: invalid modification of columns
Posted: Tue 21 Oct 2014 11:25
Hello,
when using code first migrations,
public class Model
{
public int Id { get; set; }
public string Serial { get; set; }
}
creates a coresponding table with the 'Serial' field as a NCLOB oracle type.
but when adding length restraints to the model like this
public class Model
{
public int Id { get; set; }
[StringLength(50)]
public string Serial { get; set; }
}
and adding a new migration, the type must be converted to a nvarchar type, and Update-Database command fails with
ORA-22859: invalid modification of columns
is there a workaround for this or is manual editing the only option?
Thank you
when using code first migrations,
public class Model
{
public int Id { get; set; }
public string Serial { get; set; }
}
creates a coresponding table with the 'Serial' field as a NCLOB oracle type.
but when adding length restraints to the model like this
public class Model
{
public int Id { get; set; }
[StringLength(50)]
public string Serial { get; set; }
}
and adding a new migration, the type must be converted to a nvarchar type, and Update-Database command fails with
ORA-22859: invalid modification of columns
is there a workaround for this or is manual editing the only option?
Thank you