May 2002
Beginner to intermediate
560 pages
11h 36m
English
Content preview from Essential ADO.NETBecome 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,
Start your free trial
9.8. ADO.NET for ODBC Programmers
ODBC was the first generic data access API. This API is still the API of choice among many programmers for the following reasons:
ODBC is easier to use than OLE DB/ADO because ODBC doesn't have as many choices about how to manage sets of results. In addition, many C++ programmers have trouble with OLE DB's extremely factored interfaces model and reference counting in COM.
Microsoft Foundation Classes has direct support for ODBC through CRecordset and friends.
Many manufacturers of ODBC drivers have not built OLE DB providers for their data sources. On occasion, when they have, the performance of these providers is not as good as that of the corresponding ODBC drivers.
ODBC is perceived as being faster than OLE DB, ...