VistaDB Data Types Mapping

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

.NET Type Database Column Type
Boolean Bit
Byte Int
SByte SmallInt
Char NChar
Decimal Decimal
Double Float
Single Float
Int16 SmallInt
UInt16 Int
Int32 Int
UInt32 BigInt
Int64 BigInt
UInt64 BigInt
Guid UniqueIdentifier
String NVarChar
DateTime DateTime
TimeSpan Float
Byte[] VarBinary
Unlimited size string NText
See Also