The data types available for SQL data types are as follows:
List of data types belonging to base data types
Data types belonging to these base data types are supported whether you automatically generate applications using tools in Visual Studio (Query Builder in TableAdapter and Server Explorer), or create applications yourself (with Data Provider).
SQL data types | Npgsql | |
|---|---|---|
Data type | .NET CLS data type | |
character | NpgsqlDbType.Char | System.String |
character varying | NpgsqlDbType.Varchar | System.String |
national character | NpgsqlDbType.NChar | System.String |
national character varying | NpgsqlDbType.NVarchar | System.String |
text | NpgsqlDbType.Text | System.String |
bytea | NpgsqlDbType.Bytea | System.Byte[] |
smallint | NpgsqlDbType.Smallint | System.Int16 |
integer | NpgsqlDbType.Integer | System.Int32 |
bigint | NpgsqlDbType.Bigint | System.Int64 |
smallserial | NpgsqlDbType.Smallint | System.Int16 |
serial | NpgsqlDbType.Integer | System.Int32 |
bigserial | NpgsqlDbType.Bigint | System.Int64 |
real | NpgsqlDbType.Real | System.Single |
double precision | NpgsqlDbType.Double | System.Double |
numeric | NpgsqlDbType.Numeric | System.Decimal |
decimal | NpgsqlDbType.Numeric | System.Decimal |
date | NpgsqlDbType.Date | System.DateTime |
NpgsqlTypes.NpgsqlDate | ||
time with time zone | NpgsqlDbType.TimeTZ | System.DateTimeOffset |
NpgsqlTypes.NpgsqlTimeTZ | ||
time without time zone | NpgsqlDbType.Time | System.DateTime |
NpgsqlTypes.NpgsqlTime | ||
timestamp without time zone | NpgsqlDbType.Timestamp | System.DateTime |
NpgsqlTypes.NpgsqlTimeStamp | ||
timestamp with time zone | NpgsqlDbType.TimestampTZ | System.DateTime |
NpgsqlTypes.NpgsqlTimeStampTZ | ||
interval | NpgsqlDbType.Interval | System.TimeSpan |
boolean | NpgsqlDbType.Boolean | System.Boolean |
bit | NpgsqlDbType.Bit | System.Boolean |
NpgsqlTypes.BitString | ||
uuid | NpgsqlDbType.Uuid | System.Guid |
inet | NpgsqlDbType.Inet | NpgsqlTypes.NpgsqlInet |
System.Net.IPAddress | ||
macaddr | NpgsqlDbType.MacAddr | NpgsqlTypes.NpgsqlMacAddress |
System.Net.NetworkInformation.PhysicalAddress | ||
box | NpgsqlDbType.Box | NpgsqlTypes.NpgsqlBox |
circle | NpgsqlDbType.Circle | NpgsqlTypes.NpgsqlCircle |
lseg | NpgsqlDbType.LSeg | NpgsqlTypes.NpgsqlLSeg |
path | NpgsqlDbType.Path | NpgsqlTypes.NpgsqlPath |
point | NpgsqlDbType.Point | NpgsqlTypes.NpgsqlPoint |
polygon | NpgsqlDbType.Polygon | NpgsqlTypes.NpgsqlPolygon |
array | NpgsqlDbType.Array | System.Array |
