对于以下SQL Server数据类型，C#中对应的数据类型是什么？
Exact Numerics
bigint
numeric
bit
smallint
decimal
smallmoney
int
tinyint
money
Approximate Numerics
float
real
Date and Time
date
datetimeoffset
datetime2
smalldatetime
datetime
time
Character Strings
char
varchar
text
Unicode Character Strings个
nchar
nvarchar
ntext
Binary Strings
binary
varbinary
image
Other Data Types
cursor
timestamp
hierarchyid
uniqueidentifier
sql_variant
xml
table
(来源:MSDN)
这是SQL Server 2005美元.该表有SQL Server 2008、SQL Server 2008 R2、SQL Server 2012和SQL Server 2014的更新版本.
下表列出了Microsoft SQL Server数据类型、System.Data.SqlTypes命名空间中SQL Server公共语言运行时(CLR)中的等效数据类型，以及Microsoft SQL Server中的本机CLR等效数据类型.NET框架.
| SQL Server data type | CLR data type (SQL Server) | CLR data type (.NET Framework) |
|---|---|---|
| varbinary | SqlBytes, SqlBinary | Byte[] |
| binary | SqlBytes, SqlBinary | Byte[] |
| varbinary(1), binary(1) | SqlBytes, SqlBinary | byte, Byte[] |
| image | None | None |
| varchar | None | None |
| char | None | None |
| nvarchar(1), nchar(1) | SqlChars, SqlString | Char, String, Char[] |
| nvarchar | SqlChars, SqlString | String, Char[] |
| nchar | SqlChars, SqlString | String, Char[] |
| text | None | None |
| ntext | None | None |
| uniqueidentifier | SqlGuid | Guid |
| rowversion | None | Byte[] |
| bit | SqlBoolean | Boolean |
| tinyint | SqlByte | Byte |
| smallint | SqlInt16 | Int16 |
| int | SqlInt32 | Int32 |
| bigint | SqlInt64 | Int64 |
| smallmoney | SqlMoney | Decimal |
| money | SqlMoney | Decimal |
| numeric | SqlDecimal | Decimal |
| decimal | SqlDecimal | Decimal |
| real | SqlSingle | Single |
| float | SqlDouble | Double |
| smalldatetime | SqlDateTime | DateTime |
| datetime | SqlDateTime | DateTime |
| sql_variant | None | Object |
| User-defined type(UDT) | None | user-defined type |
| table | None | None |
| cursor | None | None |
| timestamp | None | None |
| xml | SqlXml | None |