Asa Data Types Mapping

XPO creates these column types when updating the Asa database schema and expects them in existing databases.

.NET Type Database Column Type
Boolean bit
Byte tinyint
SByte numeric(3,0)
Char char(1 char)
Decimal money
Double double precision
Single float
Int16 smallint
UInt16 numeric(5,0)
Int32 int
UInt32 numeric(10,0)
Int64 bigint
UInt64 numeric(20,0)
Guid uniqueidentifier
String varchar
DateTime datetime
TimeSpan double precision
Byte[] image
Unlimited size string text
See Also