DbType
Specifies the data type of a field, a property, or a Parameter object of a .NET Framework data provider.
AnsiString = 0
A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters.
A fixed-length stream of non-Unicode characters.
Binary = 1
A variable-length stream of binary data ranging between 1 and 8,000 bytes.
Boolean = 3
A simple type representing Boolean values of true or false.
Byte = 2
An 8-bit unsigned integer ranging in value from 0 to 255.
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 = 5
A type representing a date value.
DateTime = 6
A type representing a date and time value.
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 = 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 = 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 = 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 = 9
A globally unique identifier (or GUID).
Int16 = 10
An integral type representing signed 16-bit integers with values between -32768 and 32767.
Int32 = 11
An integral type representing signed 32-bit integers with values between -2147483648 and 2147483647.
Int64 = 12
An integral type representing signed 64-bit integers with values between -9223372036854775808 and 9223372036854775807.
Object = 13
A general type representing any reference or value type not explicitly represented by another DbType value.
SByte = 14
An integral type representing signed 8-bit integers with values between -128 and 127.
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 = 16
A type representing Unicode character strings.
StringFixedLength = 23
A fixed-length string of Unicode characters.
Time = 17
A type representing a SQL Server DateTime value. If you want to use a SQL Server time value, use Time.
UInt16 = 18
An integral type representing unsigned 16-bit integers with values between 0 and 65535.
UInt32 = 19
An integral type representing unsigned 32-bit integers with values between 0 and 4294967295.
UInt64 = 20
An integral type representing unsigned 64-bit integers with values between 0 and 18446744073709551615.
VarNumeric = 21
A variable-length numeric value.
Xml = 25
A parsed representation of an XML document or fragment.