Entity Framework Mapping SQL Server tinyint to Int16

Question

My Entity Data Model is giving me this error:

Error 2019: Member Mapping specified is not valid. The type 'Edm.Int16[Nullable=True,DefaultValue=]' of ... is not compatible with 'SqlServer.tinyint[Nullable=True,DefaultValue=]' of ...

I've tried deleting and recreating the property. I don't know what I've done wrong.

Joel C · Accepted Answer · 2017-04-10 18:12:03Z

82

A tinyint should get mapped to a .NET byte; Int16 should be the corresponding type for a smallint in SQL.

edited Apr 10, 2017 at 18:12

answered May 2, 2011 at 22:32

Joel C

5,5871 gold badge23 silver badges32 bronze badges

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

2 Comments

Zack Peterson Over a year ago

Thanks. I was working with a tinyint but thinking of a smallint.

Marco Lackovic Over a year ago

It also works with byte for tinyint and short for smallint.

Collectives™ on Stack Overflow

Entity Framework Mapping SQL Server tinyint to Int16

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related