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