|
.NET Framework Type |
ADO.NET Database Type |
SQL Data Type |
|
String |
Varchar |
Varchar() |
|
String |
Nvarchar |
Nvarchar() |
|
String |
NChar |
Nchar() |
|
String |
NText |
NText |
|
String |
Text |
Text |
|
Double |
BigInt |
Float |
|
DateTime |
DateTime |
Datetime |
|
DateTime |
SmallDateTime |
Smalldatetime |
|
Int |
Int |
Int |
|
Int64 |
BigInt |
Bigint |
|
Int16 |
SmallInt |
smallint |
|
Byte[] |
Binary |
Binary() |
|
Byte[] |
Image |
Image |
|
Byte[] |
VarBinary |
Varbinary() |
|
Byte |
TinyInt |
Tinyint |
|
Bool |
Bit |
Bit |
|
Decimal |
Decimal |
Decimal |
|
Decimal |
Money |
Money |
|
Decimal |
SmallMoney |
SmallMoney |
|
Float |
Float |
Float |
|
Guid |
UniqueIdentifier |
Uniqueidentifier |
|
Real |
Real |
Real |
By Bryan Xu