LinqConnect Documentation
Data Type Mapping

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