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 | 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, 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 |