Table of contents
Type Comparisons
.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 |