Advantage Data Types Mapping

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

.NET Type Database Column Type
Boolean logical
Byte short
SByte short
Char nchar(1) or char(1)
Decimal money
Double double
Single double
Int16 short
UInt16 integer
Int32 integer
UInt32 money
Int64 numeric(20,0)
UInt64 numeric(21,0)
Guid char(36)
String nchar(N) or char(N)
DateTime timestamp
TimeSpan double
Byte[] blob
Unlimited size string nmemo or memo

Mapping Properties To Database Column Types Not Supported By Default

If a column type is not listed in the above table but can be converted to any of the listed type by the database, it can be read and modified by XPO. To create a column of a specific type in the database when updating the schema, decorate the property with DbTypeAttribute. If a column type cannot be converted to a supported type, it is possible to support such columns by creating a custom connection provider. Here are some examples:

See Also