SQL Server数据类型,System.Data.SqlDbType,.NET数据类型
SQL Server数据类型 |
System.Data.SqlDbType |
.NET数据类型 |
int |
SqlDbType.Int |
int |
varchar |
SqlDbType.VarChar |
string |
bit |
SqlDbType.Bit |
bool |
datetime |
SqlDbType.DateTime |
DateTime |
decimal |
SqlDbType.Decimal |
Decimal |
float |
SqlDbType.Float |
Double |
image |
SqlDbType.Image |
Byte[] |
money |
SqlDbType.Money |
Single |
ntext |
SqlDbType.NText |
string |
nvarchar |
SqlDbType.NVarChar |
string |
smalldatetime |
SqlDbType.SmallDateTime |
DateTime |
smallint |
SqlDbType.SmallInt |
Int16 |
text |
SqlDbType.Text |
string |
bigint |
SqlDbType.BigInt |
Int64 |
binary |
SqlDbType.Binary |
Byte[] |
char |
SqlDbType.Char |
string |
nchar |
SqlDbType.NChar |
string |
numeric |
SqlDbType.Decimal |
Decimal |
real |
SqlDbType.Real |
Single |
smallmoney |
SqlDbType.SmallMoney |
Single |
sql_variant |
SqlDbType.Variant |
Object |
timestamp |
SqlDbType.Timestamp |
Byte[] |
tinyint |
SqlDbType.TinyInt |
Byte |
uniqueidentifier |
SqlDbType.UniqueIdentifier |
Guid |
varbinary |
SqlDbType.VarBinary |
Byte[] |
xml |
SqlDbType.Xml |
|
原文地址:https://www.cnblogs.com/paullam/p/4508750.html