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 PostgreSQL table columns are mapped to the entity properties of LinqConnect model.

    PostgreSQL data type CLR data type
    bool System.Boolean
    int2, smallint System.Int16
    int2vector System.Int16[]
    int, integer, int4, oid, oidvector System.Int32
    oidvector System.Int32[]
    big, int8, bigserial System.Int64
    real, single, float4 System.Single
    double precision, double, float, float8, money System.Double
    numeric System.Decimal
    date, timestamp, timestamptz, timestamp with time zone System.DateTime
    time, interval, timetz, time with time zone System.TimeSpan
    box, character, char, character varying, varchar, cid, cidr, circle, inet, json, jsonb, line, lseg, macaddr, path, point, polygon, text, bit, bit varying, varbit, xid, name, tid, cursor, abstime System.String
    bytea System.Byte[]
    bit, varbit System.Collections.BitArray