dotConnect for SQL Server Documentation
Devart.Data.SqlServer Namespace / SqlType Enumeration

In This Topic
    SqlType Enumeration
    In This Topic
    Specifies the data type of a field or a SqlParameter.
    Syntax
    'Declaration
     
    Public Enum SqlType 
       Inherits System.Enum
       Implements System.IComparableSystem.IConvertibleSystem.IFormattable 
    Members
    MemberDescription
    BigIntInt64. A 64-bit signed integer.
    BinaryArray of type Byte. A fixed-length stream of binary data ranging between 1 and 8,000 bytes.
    BitBoolean. An unsigned numeric value that can be 0, 1, or a null reference (Nothing in Visual Basic).
    CharString. A fixed-length stream of non-Unicode characters ranging between 1 and 8,000 characters.
    DateDate. Date can be in range from January 1, 0001 to December 31, 9999.
    DateTimeDateTime. Date and time data ranging in value from January 1, 1753 to December 31, 9999 to an accuracy of 3.33 milliseconds.
    DateTime2DateTime. Date and time data ranging in value from January 1, 0001 to December 31, 9999. The precision can be up to the tenth of microsecond.
    DateTimeOffsetDateTime with the UTC offset appended. Date and time data ranging in value from January 1, 0001 00:00:000000 -14:00 to December 31, 9999 23:59:59.9999999 +14:00. The precision can be up to the tenth of microsecond.
    DecimalDecimal. A fixed precision and scale numeric value between -10 38 -1 and 10 38 -1.
    FloatDouble. A floating point number within the range of -1.79E +308 through 1.79E +308.
    ImageArray of type Byte. A variable-length stream of binary data ranging from 0 to 2 31 -1 (or 2,147,483,647) bytes.
    IntInt32. A 32-bit signed integer.
    MoneyDecimal. A currency value ranging from -2 63 (or -922,337,203,685,477.5808) to 2 63 -1 (or +922,337,203,685,477.5807) with an accuracy to a ten-thousandth of a currency unit.
    NCharString. A fixed-length stream of Unicode characters ranging between 1 and 4,000 characters.
    NTextString. A variable-length stream of Unicode data with a maximum length of 2 30 - 1 (or 1,073,741,823) characters.
    NVarCharString. A variable-length stream of Unicode characters ranging between 1 and 4,000 characters. Implicit conversion fails if the string is greater than 4,000 characters.
    RealSingle. A floating point number within the range of -3.40E +38 through 3.40E +38.
    SmallDateTimeDateTime. Date and time data ranging in value from January 1, 1900 to June 6, 2079 to an accuracy of one minute.
    SmallIntInt16. A 16-bit signed integer.
    SmallMoneyDecimal. A currency value ranging from -214,748.3648 to +214,748.3647 with an accuracy to a ten-thousandth of a currency unit.
    StructuredA result set.
    TextString. A variable-length stream of non-Unicode data with a maximum length of 2 31 -1 (or 2,147,483,647) characters.
    TimeTime. The value can be in range from 00:00:00.0000000 to 23:59:59.9999999. The precision can be up to the tenth of microsecond.
    TimestampArray of type Byte. Automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows. The storage size is 8 bytes.
    TinyIntByte. An 8-bit unsigned integer.
    UdtA SQL Server 2005 user-defined type (UDT).
    UniqueIdentifierGuid. A globally unique identifier (or GUID).
    VarBinaryArray of type Byte. A variable-length stream of binary data ranging between 1 and 8,000 bytes. Implicit conversion fails if the byte array is greater than 8,000 bytes. Explicitly set the object when working with byte arrays larger than 8,000 bytes.
    VarCharString. A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters.
    VariantObject. A special data type that can contain numeric, string, binary, or date data as well as the SQL Server values Empty and Null, which is assumed if no other type is declared.
    XmlAn XML value.
    Remarks
    This table shows mappings between SqlType values, SQL Server data types, Microsoft .NET Framework types.
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             Devart.Data.SqlServer.SqlType

    Requirements

    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

    See Also