Enumeration SchemeDbType

Enumeration Members

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

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

BinaryJson: 101

Binary Json Type

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.

Json: 100
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 System.Data.SqlDbType.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.

Generated using TypeDoc