序号
|
类别
|
SQLServer
|
C Sharp
|
备注
|
1
|
整数
|
bit
|
Boolean
|
True
转换为
1False
转换为
0
|
2
|
tinyint
|
Byte
|
C Sharp
数据类型都位于
System
命名空间
| |
3
|
smallint
|
Int16
| ||
4
|
int
|
Int32
| ||
5
|
bigint
|
Int64
| ||
6
|
smallmoney
|
Decimal
| ||
7
|
money
|
Decimal
| ||
8
|
numeric
|
Decimal
| ||
9
|
decimal
|
Decimal
| ||
10
|
浮点数
|
float
|
Double
| |
11
|
real
|
Single
| ||
12
|
日期和时间
|
smalldatetime
|
DateTime
| |
13
|
datetime
|
DateTime
| ||
14
|
timestamp
|
DateTime
| ||
15
|
字符串
|
char
|
String
| |
16
|
text
|
String
| ||
17
|
varchar
|
String
| ||
18
|
nchar
|
String
| ||
19
|
ntext
|
String
| ||
20
|
nvarchar
|
String
| ||
21
|
二进制数据
|
binary
|
Byte[]
| |
22
|
varbinary
|
Byte[]
| ||
23
|
image
|
Byte[]
| ||
24
|
其他
|
uniqueidentifier
|
Guid
| |
25
|
Variant
|
Object
|