DbType DbType DbType DbType Enum

Definition

Specifies the data type of a field, a property, or a Parameter object of a .NET Framework data provider.

public enum class DbType
public enum DbType
type DbType = 
Public Enum DbType
Inheritance

Fields

AnsiString AnsiString AnsiString AnsiString 0

A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters.

AnsiStringFixedLength AnsiStringFixedLength AnsiStringFixedLength AnsiStringFixedLength 22

A fixed-length stream of non-Unicode characters.

Binary Binary Binary Binary 1

A variable-length stream of binary data ranging between 1 and 8,000 bytes.

Boolean Boolean Boolean Boolean 3

A simple type representing Boolean values of true or false.

Byte Byte Byte Byte 2

An 8-bit unsigned integer ranging in value from 0 to 255.

Currency Currency Currency Currency 4

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.

Date Date Date Date 5

A type representing a date value.

DateTime DateTime DateTime DateTime 6

A type representing a date and time value.

DateTime2 DateTime2 DateTime2 DateTime2 26

Date and time data. Date value range is from January 1,1 AD through December 31, 9999 AD. Time value range is 00:00:00 through 23:59:59.9999999 with an accuracy of 100 nanoseconds.

DateTimeOffset DateTimeOffset DateTimeOffset DateTimeOffset 27

Date and time data with time zone awareness. Date value range is from January 1,1 AD through December 31, 9999 AD. Time value range is 00:00:00 through 23:59:59.9999999 with an accuracy of 100 nanoseconds. Time zone value range is -14:00 through +14:00.

Decimal Decimal Decimal Decimal 7

A simple type representing values ranging from 1.0 x 10 -28 to approximately 7.9 x 10 28 with 28-29 significant digits.

Double Double Double Double 8

A floating point type representing values ranging from approximately 5.0 x 10 -324 to 1.7 x 10 308 with a precision of 15-16 digits.

Guid Guid Guid Guid 9

A globally unique identifier (or GUID).

Int16 Int16 Int16 Int16 10

An integral type representing signed 16-bit integers with values between -32768 and 32767.

Int32 Int32 Int32 Int32 11

An integral type representing signed 32-bit integers with values between -2147483648 and 2147483647.

Int64 Int64 Int64 Int64 12

An integral type representing signed 64-bit integers with values between -9223372036854775808 and 9223372036854775807.

Object Object Object Object 13

A general type representing any reference or value type not explicitly represented by another DbType value.

SByte SByte SByte SByte 14

An integral type representing signed 8-bit integers with values between -128 and 127.

Single Single Single Single 15

A floating point type representing values ranging from approximately 1.5 x 10 -45 to 3.4 x 10 38 with a precision of 7 digits.

String String String String 16

A type representing Unicode character strings.

StringFixedLength StringFixedLength StringFixedLength StringFixedLength 23

A fixed-length string of Unicode characters.

Time Time Time Time 17

A type representing a SQL Server DateTime value. If you want to use a SQL Server time value, use Time.

UInt16 UInt16 UInt16 UInt16 18

An integral type representing unsigned 16-bit integers with values between 0 and 65535.

UInt32 UInt32 UInt32 UInt32 19

An integral type representing unsigned 32-bit integers with values between 0 and 4294967295.

UInt64 UInt64 UInt64 UInt64 20

An integral type representing unsigned 64-bit integers with values between 0 and 18446744073709551615.

VarNumeric VarNumeric VarNumeric VarNumeric 21

A variable-length numeric value.

Xml Xml Xml Xml 25

A parsed representation of an XML document or fragment.

Remarks

The type of a parameter is specific to the .NET Framework data provider. Specifying the type converts the value of the Parameter to the data provider Type before passing the value to the data source. If the type is not specified, ADO.NET infers the data provider Type of the Parameter from the Value property of the Parameter object.

You can also generically specify the type of a Parameter by setting DbType property of a Parameter object.

ADO.NET cannot correctly infer the type if a byte array is larger than 8,000 bytes. Explicitly specify the DbType when working with byte arrays larger than 8,000 bytes.

Applies to