SQL Server data types |
System.Data.SqlDbType |
. NET data type |
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 |
|
SQL Server data type, system.data.sqldbtype,.net data type