CODEWITHSUNDEEP
sql-serveredmxentity-framework-mapping
sumanth
sumanth

Reputation: 65

What is the best way to re-name a column in edmx?

I am using entity framework 4.0 my approach is Database first approach. what is the best way to rename a column name or change the data type of column in edmx.

thanks in advance.

Upvotes: 5

Views: 1930

Answers (1)

Markus Jarderot
Markus Jarderot

Reputation: 89231

To rename a column:

  1. Rename the column in SQL Management Studio.
  2. In the EDMX editor, choose "Update from Database", and complete the wizard. You will get a new column with the updated name, and an error-message saying that the old column is not mapped.
  3. Remove the old column.

To change the datatype:

  1. Update the datatype in SQL Management Studio.
  2. In the EDMX editor, choose "Update from Database", and complete the wizard. You will get an error message saying that the mapping is invalid.
  3. Change the datatype of the column to match what you chose in SQL Management Studio.

Upvotes: 7

Related Questions