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
See also