AnsiString | 0 | A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters. |
AnsiStringFixedLength | 22 | A fixed-length stream of non-Unicode characters. |
Binary | 1 | binary data (1 through 8000 bytes) |
Boolean | 3 | |
Byte | 2 | |
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 GUID |
Int16 | 10 | Integer value between -32768 and 32767. |
Int32 | 11 | Integer value -2147483648 and 2147483647. |
Int64 | 12 | Integer value 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 | Unsigned integer value between 0 and 65535. |
UInt32 | 19 | Unsigned integer value between 0 and 4294967295. |
UInt64 | 20 | Unsigned integer value between 0 and 18446744073709551615. |
VarNumeric | 21 | A variable-length numeric value. |
Xml | 25 | A parsed representation of an XML document or fragment. |