A.1. DbType Enumeration

Table A-1 is the DbType enumeration from the System.Data namespace.

Table A-1. DbType enumeration members and meanings
Member Name Description
AnsiString A variable-length stream of non-Unicode characters ranging between 1 and 8,000 characters.
Binary A variable-length stream of binary data ranging between 1 and 8,000 bytes. Note: ADO.NET cannot correctly infer the type if the byte array is greater than 8,000 bytes. Explicitly set the object when working with byte arrays larger than 8,000 bytes.
Boolean A simple type representing Boolean values of true or false.
Byte An 8-bit unsigned integer.
Currency A currency value ranging from –263 (or –922,337,203,685,477.5808) to 263 –1 (or +922,337,203,685,477.5807) with an accuracy ...

Get Essential ADO.NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.