How Are Data Types Converted in Orders Mapped Storage?
The following table describes how data is converted from a runtime object to an entry in an SQL database, and from an entry in an SQL database back to a runtime object.
.NET Data Type |
SQL Data Type |
|---|---|
Boolean |
Bit |
DateTime |
Datetime |
Decimal |
Money |
Decimal |
Numeric |
Double |
Float |
Guid |
Uniqueidentifier |
Int16 |
Smallint |
Int32 |
Int |
Int64 |
Bigint |
Single |
Real |
String |
Nchar |
String |
Nvarchar |
String |
Ntext |
The Orders System does not support the following SQL data types:
Binary
Char
Decimal
Image
Smalldatetime
Smallmoney
SQLVariant
Sysname
Text
Tinyint
Varbinary
Varchar