PostgreSQL 和 C# 数据类型
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/845458/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
PostgreSQL and C# Datatypes
提问by Higty
I searched type convertion table between PostgreSQL and C#, but I couldn't find anything. I'll research empty cell on above table if I have time. But if you know the web page which has these information, I'm very appropriate to your help.
我搜索了 PostgreSQL 和 C# 之间的类型转换表，但我找不到任何东西。如果我有时间，我会研究上表中的空单元格。但是如果你知道有这些信息的网页，我非常适合你的帮助。
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
采纳答案by splattne
Maybe you can find something looking through the documentation of Npgsql, which is an implementation of a .NET Data Provider for PostgreSQL.
也许您可以通过Npgsql的文档找到一些东西 ，它是 PostgreSQL 的 .NET 数据提供程序的实现。
This page of the documentationactually contains a complete table of what you are looking for. Search for "4. Current Npgsql Status" - "Supported data types". There is a nice table with all PostgreSQL data types and their correspondents in .NET.
该文档页面实际上包含您要查找的内容的完整表格。搜索“4. 当前 Npgsql 状态”-“支持的数据类型”。有一个很好的表格，其中包含所有 PostgreSQL 数据类型及其在 .NET 中的对应关系。
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
