SQL Server 内置数据类型与 DotNet数据类型对应关系
TypeName |
DataType |
IsAutoIncrementable |
IsBestMatch |
bigint |
System.Int64 |
TRUE |
TRUE |
binary |
System.Byte[] |
FALSE |
TRUE |
char |
System.String |
FALSE |
TRUE |
datetime |
System.DateTime |
FALSE |
TRUE |
datetime2 |
System.DateTime |
FALSE |
TRUE |
datetimeoffset |
System.DateTimeOffset |
FALSE |
TRUE |
decimal |
System.Decimal |
TRUE |
TRUE |
float |
System.Double |
FALSE |
TRUE |
image |
System.Byte[] |
FALSE |
TRUE |
int |
System.Int32 |
TRUE |
TRUE |
nchar |
System.String |
FALSE |
TRUE |
ntext |
System.String |
FALSE |
TRUE |
numeric |
System.Decimal |
TRUE |
TRUE |
nvarchar |
System.String |
FALSE |
TRUE |
real |
System.Single |
FALSE |
TRUE |
smalldatetime |
System.DateTime |
FALSE |
TRUE |
smallint |
System.Int16 |
TRUE |
TRUE |
sql_variant |
System.Object |
FALSE |
TRUE |
text |
System.String |
FALSE |
TRUE |
tinyint |
System.SByte |
TRUE |
TRUE |
uniqueidentifier |
System.Guid |
FALSE |
TRUE |
varbinary |
System.Byte[] |
FALSE |
TRUE |
varchar |
System.String |
FALSE |
TRUE |
原文地址:https://www.cnblogs.com/pyblogs/p/3491474.html