How to rename a database column in Entity Framework 5 Code First migrations without losing data?

c# .net entity-framework entity-framework-5
Dante picture Dante · Oct 28, 2012 · Viewed 38k times · Source

I got the default ASP.NET MVC 4 template successfully running with EF 5.0 Code First Migrations. However, when I update a model property name, the corresponding table column data is dropped by EF 5.0.

Is it somehow possible to rename the table column without dropping data in an automated way?

Answer

Josh Gallagher picture Josh Gallagher · Nov 29, 2012

Manually edit the Up and Down methods of the migration to use the RenameColumn method to replace the AddColumn and DropColumn that it automatically generates for you.

Related questions

EF5 Getting this error message: Model compatibility cannot be checked because the database does not contain model metadata

I have this error message that keeps on displaying every time I run the application. I'm using Entity Framework 5: Code First Here's the error message, System.NotSupportedException: Model compatibility cannot be checked because the database does not contain model metadata. …

Read More
Entity Framework Multiple Column as Primary Key by Fluent Api

These are my simplified domain classes. public class ProductCategory { public int ProductId { get; set; } public int CategoryId { get; set; } public virtual Product Product { get; set; } public virtual Category Category { get; set; } } public class Product { public int Id { get; set; } public …

Read More
How do I specify the maximum column length of a field using entity framework code first

Is there an attribute I can use when creating a table ? I tried [StringLength] but it seems to be ignored. public class EntityRegister { public int Id { get; set; } [StringLength(450)] public string Name { get; set; } }

Read More