LinqConnect Documentation
In This Topic
    Data Type Mapping
    In This Topic
    Data Type Mapping
    LinqConnect Documentation
    Data Type Mapping
    [email protected]

    Type mapping rules from this table are used when Oracle table columns are mapped to the entity properties of LinqConnect model.

    Oracle data type CLR data type
    INTERVAL YEAR TO MONTH, INTERVAL YEAR, NUMBER(1) - NUMBER(9) System.Int32
    NUMBER(10) - NUMBER(22), BINARY_DOUBLE, System.Double
    FLOAT(1) - FLOAT(10), BINARY_FLOAT System.Single
    NUMBER, FLOAT(11) - FLOAT(...) System.Decimal
    DATE, TIMESTAMP, TIMESTAMP WITH TIME ZONE, TIMESTAMP WITH LOCAL TIME ZONE System.DateTime
    INTERVAL DAY TO SECOND System.TimeSpan
    VARCHAR2, NVARCHAR2, CHAR, NCHAR, URITYPE, LONG, ROWID, UROWID, CLOB, NCLOB, XMLTYPE System.String
    RAW(16) System.Guid
    RAW, BLOB, BFILE, LONG RAW System.Byte[]

    NoteNote:

    Please note, that the mapping rules of NUMBER and FLOAT data types can change in dependence of the field size. For example, NUMBER(1)-NUMBER(9) will be mapped to the System.Int32, but NUMBER(10) - NUMBER(22) will be mapped to the double. NUMBER field without size definition will be mapped to the decimal. If you have a NUMBER(x, y) where y <> 0 or x > 15 then this value should be mapped to decimal.