| 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