SQL类型 | C#类型 |
---|---|
bit | bool |
tinyint | byte |
smallint | short |
int | int |
bigint | long |
real | float |
float | double |
money | decimal |
datetime | DateTime |
char | string |
varchar | string |
nchar | string |
nvarchar | string |
text | string |
ntext | string |
image | byte[] |
binary | byte[] |
uniqueidentifier | Guid |
Postgresql NpgsqlDbType System.DbType Enum .Net System Type
---------- ------------ ------------------ ----------------
int8 Bigint Int64 Int64
bool Boolean Boolean Boolean
bytea Bytea Binary Byte[]
date Date Date DateTime
float8 Double Double Double
int4 Integer Int32 Int32
money Money Decimal Decimal
numeric Numeric Decimal Decimal
float4 Real Single Single
int2 Smallint Int16 Int16
text Text String String
time Time Time DateTime
timetz Time Time DateTime
timestamp Timestamp DateTime DateTime
timestamptz TimestampTZ DateTime DateTime
interval Interval Object TimeSpan
varchar Varchar String String
inet Inet Object IPAddress
bit Bit Boolean Boolean
uuid Uuid Guid Guid
array Array Object Array
Postgre Type --->C# Type
bigint --->Int64
bigserial --->
bit [ (n) ] --->Byte[]
bit varying [ (n) ] --->Byte
boolean --->Boolean
box --->
bytea --->Byte[]
character varying [ (n) ] ---> String
character --->String
cidr
circle
date --->DateTime
double precision --->Double
inet
integer --->Int32
interval [ (p) ] --->TimeSpan
line
lseg
macaddr
money
numeric [ (p, s) ] --->Decimal
decimal [ (p, s) ] --->Decimal
path
point
polygon
real --->Single
smallint --->Int16
serial
text --->String
time [ (p) ] [ without time zone ] --->
time [ (p) ] with time zone --->
timestamp [ (p) ] [ without time zone ] --->
timestamp [ (p) ] with time zone --->
tsquery
tsvector
txid_snapshot
uuid --->Guid
xml