'Declaration Public Enum UniDbType Inherits System.Enum Implements System.IComparable, System.IConvertible, System.IFormattable
public enum UniDbType : System.Enum, System.IComparable, System.IConvertible, System.IFormattable
'Declaration Public Enum UniDbType Inherits System.Enum Implements System.IComparable, System.IConvertible, System.IFormattable
public enum UniDbType : System.Enum, System.IComparable, System.IConvertible, System.IFormattable
| Member | Description |
|---|---|
| Array | An Oracle VARRAY data type representing a variable-length array. Supported for dotConnect for Oracle and Oracle Client only. This type does not have corresponding .NET Framework type. |
| BigInt | An integer data type. Represented as NUMBER in Oracle, BIGINT in SQL Server, MySQL, and PostgreSQL. Corresponds to Int64 in the .NET Framework. |
| Binary | Raw data type. Represented as RAW in Oracle, BINARY in SQL server, MySQL, BYTEA in PostgreSQL. Corresponds to array of bytes in the .NET Framework. |
| Bit | Bit data type. Represented as INTEGER in Oracle, BIT in SQL Server, MySQL and PostgreSQL. Corresponds to Int16 in the .NET Framework. |
| Blob | Binary LOB data type. Represented as IMAGE in SQL Server, BLOB in Oracle and MySQL, BYTEA in PostgreSQL. May be represented as UniBlob class or an array of bytes in the .NET Framework. |
| Boolean | Boolean data type. Represented as BOOLEAN in Oracle and PostgreSQL, BIT in SQL Server and MySQL. Corresponds to Boolean in the .NET Framework. |
| Byte | Byte data type. Represented as INTEGER in Oracle, SMALLINT in SQL Server and MySQL, BYTE in PostgreSQL. Corresponds to Int16 in the .NET Framework. |
| Char | Fixed-length char data type. Represented as CHAR in SQL Server, Oracle, MySQL and PostgreSQL. Corresponds to String in the .NET Framework. |
| Clob | Character LOB data type. Represented as CLOB in Oracle, TEXT in SQL Server, MySQL and PostgreSQL. May be represented as UniBlob class or string in the .NET Framework. |
| Currency | Currency data type. Represented as NUMBER in Oracle, DOUBLE in MySQL, and MONEY in SQL Server and PostgreSQL. Corresponds to Decimal in the .NET Framework. |
| Cursor | An Oracle Cursor data type. May be represented as UniCursor or UniDataReader. |
| Date | Date data type. Represented as DATETIME in SQL Server, DATE in Oracle, MySQL and PostgreSQL. Corresponds to DateTime in the .NET Framework. |
| DateTime | DateTime data type. Represented as DATETIME in SQL Server and MySQL, DATE in Oracle, and TimeStamp in PostgreSQL. Corresponds to DateTime in the .NET Framework. |
| DateTime2 | DateTime data type. Represented as DATETIME2 in SQL Server. |
| Decimal | Wide range numeric data type. Represented as NUMBER in Oracle, DECIMAL in SQL Server and MySQL, and NUMERIC in PostgreSQL. Corresponds to Decimal in the .NET Framework. |
| Double | Floating point data type. Represented as REAL in SQL Server, DOUBLE in Oracle, MySQL and PostgreSQL. Corresponds to Double in the .NET Framework. |
| Guid | GUID-like data type. Represented as VARCHAR in Oracle, MySQL and PostgreSQL. In SQL Client this is UNIQUEIDENTIFIER. Corresponds to Guid in the .NET Framework. |
| Int | Integer data type. Represented as INTEGER in Oracle, INT in SQL Server, MySQL and PostgreSQL. Corresponds to Int32 in the .NET Framework. |
| IntervalDS | Time interval data type measured in Day or smaller units. Represented as INTERVAL DAY TO SECOND in data providers for Oracle and INTERVAL in PostgreSQL. For other data providers this type is not supported. Corresponds to TimeSpan in the .NET Framework. |
| IntervalYM | Time interval data type measured in Year and Month units. Represented as INTERVAL YEAR TO MONTH in data providers for Oracle and INTERVAL in PostgreSQL. For other data providers this type is not supported. Corresponds to TimeSpan in the .NET Framework. |
| NChar | Fixed-length char data type with national encoding. Represented as NCHAR in SQL Server and Oracle, CHAR in MySQL and PostgreSQL. |
| NClob | National character LOB data type. Represented as NCLOB in Oracle, TEXT in SQL Server, MySQL and PostgreSQL. May be represented as UniBlob class or string in the .NET Framework. |
| NVarChar | Varchar data type with national encoding. Represented as NVARCHAR in SQL Server and Oracle, VARCHAR in MySQL and PostgreSQL. Corresponds to String in the .NET Framework. |
| Object | One of the Oracle object types defined by the user. Corresponds to Object in the .NET Framework. |
| Single | Floating point data type. Represented as FLOAT in SQL Server, Oracle and MySQL, REAL in PostgreSQL. Corresponds to Double in the .NET Framework. |
| SmallInt | Integer data type. Represented as INTEGER in Oracle, SMALLINT in SQL Server, MySQL and PostgreSQL. Corresponds to Int16 in the .NET Framework. |
| Time | Time data type. Represented as DATETIME in SQL Server, DATE in Oracle, TIME in MySQL and PostgreSQL. Corresponds to DateTime in the .NET Framework. |
| TimeStamp | TimeStamp data type. Represented as DATETIME in SQL Server, TIMESTAMP in Oracle, MySQL and PostgreSQL. Corresponds to DateTime in the .NET Framework. |
| TimeStampTZ | TimeStamp with time zone data type. Represented as DATETIMEOFFSET in SQL Server, TIMESTAMP WITH TIMEZONE in Oracle and PostgreSQL. Corresponds to DateTime in the .NET Framework. |
| TinyInt | Integer data type. Represented as INTEGER in Oracle, TYNIINT in SQL Server and MySQL, and SMALLINT in PostgreSQL. Corresponds to Int16 in the .NET Framework. |
| VarChar | Variable-length character data type. Represented as VARCHAR in SQL Server, Oracle, MySQL and PostgreSQL. Corresponds to String in the .NET Framework. |
| Xml | XML data type. Represented as XMLTYPE in Oracle, VARCHAR in MySQL and PostgreSQL. Corresponds to Object in the .NET Framework. |
A UniDbType value is mapped to corresponding server type whenever possible. If no strict correspondence can be established, the value is mapped to the closest possible server type. For information on how UniDbType maps to SQL Server, Oracle, MySQL and PostgreSQL, refer to corresponding topics in the Specific Notes section.
UniDbType is an advanced solution to problem of defining types that do not fall within range of System.Data.DbType. Particularly, UniDbType allows you to control exact type of UniParameters and UniBlobs. Using UniDbType, you can choose exact UniBlob kind (BLOB, CLOB or NCLOB), work with UniDecimal and UniCursor.
Usually UniDbType is used when handling UniParameter objects. When you set UniParameter.UniDbType, the UniParameter.DbType is automatically adjusted, and vice versa.
For information on using LOB kinds of UniDbType refer to article Working with BLOB Data.
For information on using UniCursor refer to article Working with Cursors.
For information on using UniDecimal refer to corresponding reference section.
For general information and examples on using the UniDbType enumeration visit UniParameter reference.
System.Object
System.ValueType
System.Enum
Devart.Data.Universal.UniDbType
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2