How Are Data Types Converted in Orders Mapped Storage?
For the latest version of Commerce Server 2007 Help, see the Microsoft Web site.
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