Hi
I am trying to query a table with a column of type number(5,0). It seems like the default mapping for number(5,0) is Int16 (or "short"), which results in a System.OverflowException:
Value was either too large or too small for an Int16.
In the stacktrace I see, that it tries to convert an Int32 to Int16 which is odd.
If I go to the model browser and change the .NET runtime type to Int32 I instead get a System.Data.Entity.Core.MappingException:
Member Mapping specified is not valid. The type 'Edm.Int32[Nullable=False,DefaultValue=]' of member 'xxx' in type 'Model.xxx' is not compatible with 'OracleEFProvider.number[Nullable=False,DefaultValue=,Precision=5,Scale=0]'
Somehow it is not allowed to map a number(5,0) to Int32.
How do you overcome that problem?
Thanks!