Skip to Content
Essential ADO.NET
book

Essential ADO.NET

by Bob Beauchemin
May 2002
Beginner to intermediate content levelBeginner to intermediate
560 pages
11h 36m
English
Addison-Wesley Professional
Content preview from Essential ADO.NET

A.4. Mapping of ODBC Types

Table A-4 maps the members of the OdbcType enumeration to ODBC data types and the .NET type system.

Table A-4. The OdbcType enumeration
Member Name Description
BigInt Exact numeric value with precision 19 (if signed) or 20 (if unsigned) and scale 0 (signed: –2[63] <= n <= 2[63] – 1, unsigned: 0 <= n <= 2[64] – 1) (SQL_BIGINT). This maps to Int64.
Binary A stream of binary data (SQL_BINARY). This maps to an Array of type Byte.
Bit Single bit binary data (SQL_BIT). This maps to Boolean.
Char A fixed-length character string (SQL_CHAR). This maps to String.
DateTime Date data in the format yyyymmdd (SQL_TYPE_TIMESTAMP). This maps to DateTime.
Decimal Signed, exact, numeric value with a precision of at least p and scale s, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® ADO.NET 4 Step by Step

Microsoft® ADO.NET 4 Step by Step

Tim Patrick
Professional C# 5.0 and .NET 4.5.1

Professional C# 5.0 and .NET 4.5.1

Christian Nagel, Jay Glynn, Morgan Skinner
ASP.NET 4 Unleashed

ASP.NET 4 Unleashed

Stephen Walther, Kevin Hoffman, Nate Dudek

Publisher Resources

ISBN: 0201758660Purchase book