ULDbType enumeration

Public Enum ULDbType

public enum ULDbType

Member name	Description	Value
BigInt	Signed 64-bit integer.	5
Binary	Binary data, with a specified maximum length. The Binary and VarBinary enumeration values 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 Char and VarChar types are fully compatible.	0
Date	Date information.	10
DateTime	Timestamp information (date, time). The DateTime and TimeStamp enumeration values are aliases of each other.	9
Decimal	Exact numerical data, with a specified precision and scale. The Decimal and Numeric enumeration values are aliases of each other.	14
Double	Double precision floating-point number (8 bytes).	12
Float	Single precision floating-point number (4 bytes). The Float and Real enumeration values 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 Decimal and Numeric enumeration values are aliases of each other.	14
Real	Single precision floating-point number (4 bytes). The Float and Real enumeration values are aliases of each other.	13
SmallInt	Signed 16-bit integer.	3
STGeometry	ST_Geometry information.	ULNET_TYPE_ST_GEOMETRY
Time	Time information.	11
TimeStamp	Timestamp information (date, time). The DateTime and TimeStamp enumeration values are aliases of each other.	9
TimeStampWithTimeZone	Timestamp information (date, time) along with the time zone offset.	ULNET_TYPE_TIMESTAMP_WITH_TIME_ZONE
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 Binary and VarBinary enumeration values are aliases of each other.	15
VarChar	Character data, with a specified maximum length. In UltraLite.NET, this type always supports Unicode characters. The Char and VarChar types are fully compatible.	16

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.Decimal	decimal	Decimal
Float, Real	System.Single	float	Single
BigInt	System.Int64	long	Long
Integer	System.Int32	int	Integer
SmallInt	System.Int16	short	Short
ST_Geometry	System.String	String	String
Time	System.TimeSpan	TimeSpan (no built-in type)	TimeSpan (no built-in type)
DateTime, TimeStamp	System.DateTime	DateTime (no built-in type)	Date
TimeStampWithTimeZone	System.String	String	String
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.

ULDbType enumeration

Visual Basic syntax

C# syntax

Members

Remarks

See also