Search code examples
c#oracle-databaseintshort

Number(5) in Oracle what is it meaning in C#

I created my table and one of my column area is Number(5), 

 PROJECT_CODE  NUMBER(5)  NOT NULL ,

when i entegred it in my model in c# it is look like;

  public global::System.Int16 PROJECT_CODE

my question is why it is getting to Int16 because int16 meaning short and max value is "32767" if my value will be 32768 oracle will be okay but what about c#?

Solution

  • because odpnet have a specification that inform of this state of fact.

    oracle datatype mapping for .net

    In code execution you can have an issue if you manually set a value with an incorrect range. I recommand to use same application to set value, that guarantee the process.