This topic has not yet been rated - Rate this topic

How Are Data Types Converted in Orders Mapped Storage?

Commerce Server 2007

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

Other Resources

Orders Mapped Storage

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)