Programming Data-Driven Web Applications with ASP.NET

ADO.NET Object Model

Figure B.2. The ADO.NET Document Object Model.

ADO.NET DbTypes

Table B.1. SqlDbType Compared to OleDbType

SqlDbType	OleDbType	Description
BigInt	BigInt	Int64— A 64-bit signed integer.
Binary	Binary	Array of type Byte— A fixed-length stream of binary data ranging between 1 and 8,000 bytes.
Bit	-	Boolean— An unsigned numeric value that can be 0, 1, or a null reference (Nothing in Visual Basic).
-	Boolean	Boolean— A boolean value (DBTYPE_BOOL).
-	BSTR	String— A null-terminated character string of Unicode characters (DBTYPE_BSTR).
Char	Char	String— A fixed-length stream of non-Unicode characters ranging between 1 and 8,000 characters. ...