ULDbType enumeration

Enumerates the UltraLite.NET database data types.

Syntax

Visual Basic

Public Enum ULDbType

C#

public enum ULDbType

Remarks

The table below lists which .NET types are compatible with each ULDbType. In the case of integral types, table columns can always be set using smaller integer types, but can also be set using larger types as long as the actual value is within the range of the type.

ULDbType	Compatible .NET type	C# built-in type	Visual Basic built-in type
Binary, VarBinary	System.Byte[], or System.Guid if size is 16	byte[]	Byte()
Bit	System.Boolean	bool	Boolean
Char, VarChar	System.String	String	String
Date	System.DateTime	DateTime No built-in type.	Date
Double	System.Double	double	Double
LongBinary	System.Byte[]	byte[]	Byte()
LongVarchar	System.String	String	String
Decimal, Numeric	System.String	decimal	Decimal
Float, Real	System.Single	float	Single
BigInt	System.Int64	long	Long
Integer	System.Int32	int	Integer
SmallInt	System.Int16	short	Short
Time	System.TimeSpan	TimeSpan No built-in type.	TimeSpan No built-in type.
DateTime, TimeStamp	System.DateTime	DateTime No built-in type.	Date
TinyInt	System.Byte	byte	Byte
UnsignedBigInt	System.UInt64	ulong	UInt64 No built-in type.
UnsignedInt	System.UInt32	uint	UInt32 No built-in type.
UnsignedSmallInt	System.UInt16	ushort	UInt16 No built-in type.
UniqueIdentifier	System.Guid	Guid No built-in type.	Guid No built-in type.

Binary columns of length 16 are fully compatible with the UniqueIdentifier type.

Members

Member name	Description	Value
BigInt	Signed 64-bit integer.	5
Binary	Binary data, with a specified maximum length. The enumeration values Binary and VarBinary are aliases of each other.	15
Bit	1-bit flag.	8
Char	Character data, with a specified length. In UltraLite.NET, this type always supports Unicode characters. The types Char and VarChar are fully compatible.	0
Date	Date information.	10
DateTime	Timestamp information (date, time). The enumeration values DateTime and TimeStamp are aliases of each other.	9
Decimal	Exact numerical data, with a specified precision and scale. The enumeration values Decimal and Numeric are aliases of each other.	14
Double	Double precision floating-point number (8 bytes).	12
Float	Single precision floating-point number (4 bytes). The enumeration values Float and Real are aliases of each other.	13
Integer	Unsigned 32-bit integer.	1
LongBinary	Binary data, with variable length.	18
LongVarchar	Character data, with variable length. In UltraLite.NET, this type always supports Unicode characters.	17
Numeric	Exact numerical data, with a specified precision and scale. The enumeration values Decimal and Numeric are aliases of each other.	14
Real	Single precision floating-point number (4 bytes). The enumeration values Float and Real are aliases of each other.	13
SmallInt	Signed 16-bit integer.	3
Time	Time information.	11
TimeStamp	Timestamp information (date, time). The enumeration values DateTime and TimeStamp are aliases of each other.	9
TinyInt	Unsigned 8-bit integer.	7
UniqueIdentifier	Universally Unique Identifier (UUID/GUID).	19
UnsignedBigInt	Unsigned 64-bit integer.	6
UnsignedInt	Unsigned 32-bit integer.	2
UnsignedSmallInt	Unsigned 16-bit integer.	4
VarBinary	Binary data, with a specified maximum length. The enumeration values Binary and VarBinary are aliases of each other.	15
VarChar	Character data, with a specified maximum length. In UltraLite.NET, this type always supports Unicode characters. The types Char and VarChar are fully compatible.	16

ULDbType enumeration

Syntax

Remarks

Members

See also