How Are Data Types Converted in Orders Mapped Storage?

  • Article

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

See Also

Other Resources

Orders Mapped Storage