Entity Framework maps wrong datatype

Question

I have a database with a view that has an integer FK. When I create my model in VS and look at the diagram the view has the column as a string/varchar. I have removed the table and re-added it but it still creates the entity with a string property.

If I select the view then over in Properties change Type to Int32 the build completes without errors, but breaks at the first call of the DB context saying the store and model don't match up.

DB table:

TariffKey : int
CompanyKey : int
ChargeTypeKey : int
ChargeTypeName : varchar(80)
Value : numeric
StartDate : datetime
EndDate : datetime

Model mapping:

TariffKey : int (Int32)
CompanyKey : int (Int32)
ChargeTypeKey : varchar (String)
ChargeTypeName : varchar (String)
Value : numeric (Decimal)
StartDate : datetime (DateTime)
EndDate : datetime (DateTime)

Please post the table schema and the diagram model/mapping. We need information in order to help you. — JuanR, Sep 07 '17 at 19:14
What is the type of the primary key for ChargeType? And what does the model look like for it? — johnnyRose, Sep 07 '17 at 20:34
Please post a CREATE statement for your table so we can see the actual definition as seen by SQL Server. — JuanR, Sep 07 '17 at 20:43

score 0 · Accepted Answer · edited Mar 26 '23 at 08:01

0

The Store of the Model was the problem child. So even when I changed the data type from the diagram the store still had a varchar mapped to the field. I followed Mat's answer from Update Model from Database does not see a type change

edited Mar 26 '23 at 08:01

Glorfindel

21,988
13
81
109

answered Sep 07 '17 at 21:02

toadfromgrove

143
2
14

Entity Framework maps wrong datatype

1 Answers1