Updating Entity Framework Model

Question

I have just started using EF and found it cool, but I ran into a problem,

Problem:
I changed my DB schema of a column inside the table User, It was Varbinary(50) previously I then changed it into VarChar(50), and then inside the MyModel.edmx designer I chose "Update model from database", after clicking finish I received this error.

Error:

   Error 2019: Member Mapping specified is not valid.
    The type 'Edm.Binary [Nullable=False,DefaultValue=,MaxLength=100,FixedLength=False]' of member
   'Email' in type 'LearnDBModel.User' is not compatible with SqlServer.varchar 
    [Nullable=False,DefaultValue=, MaxLength=50,Unicode=False,FixedLength=False]' of member 'Email'
    in type 'LearnDBModel.Store.User'.

Let me know how to fix it

@Xharze Actually the table in which I made changes is empty. — DayTimeCoder
– DayTimeCoder, Commented May 19, 2012 at 17:58

Shawn de Wet · Accepted Answer · 2012-05-19 18:51:18Z

61

I've run into similar issues before, and found that the way to solve it was to delete the table from the model. Save and close the model. Then reopen the model and re-add the table.

answered May 19, 2012 at 18:51

Shawn de Wet

6,0668 gold badges64 silver badges101 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

FLICKER Over a year ago

you also can cut/save/paste/save

FLICKER Over a year ago

if this did not work. you need to manually edit the .emdx file

Nacht Over a year ago

This is f**ked. I thought EF was an industry standard. Another step that you might have to do is build the project before re-adding.

Matthis Kohli Over a year ago

I am doing this that way since I came across this error and thought there had to be a better way. Seems like it doesn't :D

Shaiju T Over a year ago

I was using asp mvc database first method, what i did was, deleted the whole model, and re-created again, works fine, hope helps someone.

|

Chinh Phan · Accepted Answer · 2014-12-10 03:27:15Z

15

Shawn de Wet's solution works fine but In case you dont want to remove the table (for example relationship to some other tables..) you can use another solution: Open your edmx file with xml Editor, Ctrl + F to find a line similar to

Property Name="Email" Type="Binary" Nullable="false" MaxLength="50" FixedLength="false"

Update it to:

Property Name="Email" Type="String" Nullable="false" MaxLength="50" Unicode="false" FixedLength="false"

Save it and rebuild.

answered Dec 10, 2014 at 3:27

Chinh Phan

1,50919 silver badges22 bronze badges

Comments

Tomas Kubes · Accepted Answer · 2016-05-24 05:33:51Z

4

A lot of files in the EF model get f*****d. Removing and adding the entity was not enough. The entities was duplicated like table, table1, table_result, table1_result, table_result1, and so on... Model update was updating the duplicated references instead of the original.

I have to open notepad and fix manually these files:

EFModel.Context.cs
EFModel.edxm

And delete these files:

obj\Debug\edmxResourcesToEmbed\MYEfModel.csdl
obj\Debug\edmxResourcesToEmbed\MYEfModel.msl
obj\Debug\edmxResourcesToEmbed\MYEfModel.ssdl

edited May 24, 2016 at 5:33

answered Nov 15, 2015 at 9:15

Tomas Kubes

25.5k18 gold badges121 silver badges163 bronze badges

Comments

MSRS · Accepted Answer · 2012-05-19 19:20:10Z

1

No need to worry about it. Select the affected table in the model. If you observe, there you will find a new column name post fix with an integer (This behavior is only because of the change in the datatype of that column).

Example if your column name is "Samplecolumn", after updating the model from the database you will get a new column with Samplecolumn1. You can now simply remove the old column "Samplecolumn" and rename the new column "Samplecolumn1" to "Samplecolumn" using the properties window under general category.

Just build your app. The error will be gone.

answered May 19, 2012 at 19:20

MSRS

8138 silver badges20 bronze badges

Comments

HoganDevelopementAddicted · Accepted Answer · 2016-07-01 16:04:03Z

0

go to MyModel.edmx xml file, change Binary to String solved my issue

answered Jul 1, 2016 at 16:04

HoganDevelopementAddicted

1411 silver badge5 bronze badges

Comments

onvr · Accepted Answer · 2015-08-10 06:35:25Z

-2

right click properties from changed table on Model.edmx[Diagram] and "Update model from database" . save and run

answered Aug 10, 2015 at 6:35

onvr

11 bronze badge

Collectives™ on Stack Overflow

Updating Entity Framework Model

6 Answers 6

6 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

6 Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related