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 |