Sql Server |
C# |
简写 |
bigint |
System.Int64 |
long |
tinyint |
System.Byte |
byte |
binary(50) |
System.Byte[] |
byte[] |
image |
System.Byte[] |
byte[] |
varbinary(50) |
System.Byte[] |
byte[] |
timestamp |
System.Byte[] |
byte[] |
bit |
System.Boolean |
bool |
char(10) |
System.String |
string |
nchar(10) |
System.String |
string |
ntext |
System.String |
string |
nvarchar(50) |
System.String |
string |
varchar(50) |
System.String |
string |
text |
System.String |
string |
date |
System.DateTime |
System.DateTime |
datetime |
System.DateTime |
System.DateTime |
datetime2(7) |
System.DateTime |
System.DateTime |
smalldatetime |
System.DateTime |
System.DateTime |
datetimeoffset(7) |
System.DateTimeOffset |
System.DateTimeOffset |
time(7) |
System.TimeSpan |
System.TimeSpan |
decimal(18,0) |
System.Decimal |
decimal |
money |
System.Decimal |
decimal |
numeric(18,0) |
System.Decimal |
decimal |
smallmoney |
System.Decimal |
decimal |
float |
System.Double |
double |
int |
System.Int32 |
int |
real |
System.Single |
float |
smallint |
System.Int16 |
short
|
|
请发表评论