在.Net中的sql 数据类型有自己的一套命名,在System.Data.SqlTypes namespace里面
具体区别如下:Native SQL Server .NET Framework SqlTypes .NET Framework SqlDbType
binary SqlBinary Binary
Bigint SqlInt64 BigInt
Char SqlString Char
datetime SqlDateTime DateTime
decimal SqlDecimal Decimal
Float SqlDouble Float
image SqlBinary Image
Int SqlInt32 Int
Money SqlMoney Money
nchar SqlString NChar
Ntext SqlString NText
nvarchar SqlString NVarChar
Numeric SqlDecimal Numeric
Real SqlSingle Real
smalldatetime SqlDateTime SmallDateTime
smallint SqlInt16 SmallInt
smallmoney SqlMoney SmallMoney
sql_variant Object Variant
sysname SqlString VarChar
text SqlString Text
timestamp SqlBinary TimeStamp
tinyint SqlByte TinyInt
varbinary SqlBinary VarBinary
varchar SqlString VarChar
uniqueidentifier SqlGuid UniqueId
具体区别如下:Native SQL Server .NET Framework SqlTypes .NET Framework SqlDbType
binary SqlBinary Binary
Bigint SqlInt64 BigInt
Char SqlString Char
datetime SqlDateTime DateTime
decimal SqlDecimal Decimal
Float SqlDouble Float
image SqlBinary Image
Int SqlInt32 Int
Money SqlMoney Money
nchar SqlString NChar
Ntext SqlString NText
nvarchar SqlString NVarChar
Numeric SqlDecimal Numeric
Real SqlSingle Real
smalldatetime SqlDateTime SmallDateTime
smallint SqlInt16 SmallInt
smallmoney SqlMoney SmallMoney
sql_variant Object Variant
sysname SqlString VarChar
text SqlString Text
timestamp SqlBinary TimeStamp
tinyint SqlByte TinyInt
varbinary SqlBinary VarBinary
varchar SqlString VarChar
uniqueidentifier SqlGuid UniqueId
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货