With Entity Framework 6 and Oracle 12c and ODP.NET Managed Drivers 12c, I'm creating an Entity Framework application.
Although every application in the Oracle 12c version is functioning well, we have a client that still utilises the Oracle 11g version. When putting a number(8) value in an 11g database, I am seeing the following problem with this customer:
The member "ALARMID" of type "Model.ALARMS" requires a value of type "System.Int16," which could not be converted from a store-generated value of type "System.Int32".
The problem stops when I change my model's AlarmID field from its current value of Int16 to Int32, however the value recorded in the database shifts to a negative number. Returning to Int16, the aforementioned issue still exists.
I looked through Oracle forums, but I couldn't find anything to help me with this.
Does anybody have this kind of issue?