April 2006
Intermediate to advanced
1088 pages
24h 51m
English
Content preview from A Developer’s Guide to SQL Server 2005Become 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
14. ADO.NET 2.0 and SqlClient
IN THIS CHAPTER, we round out the functionality enhancements for SQL Server clients and go into some general ADO.NET provider-model enhancements. All these enhancements are backward compatible—that is, they work with SQL Server 2000 and SQL Server 7 as well. We'll look at these enhancements using the ADO.NET SqlClient provider, though we'll point out where equivalent new functionality is available to other ADO.NET data providers or through other APIs.
Generic Coding with the ADO.NET 2.0 Base Classes and Factories
ADO.NET is a database-agnostic API. It is an API in which database vendors write plug-in data providers for their database … la OLE DB/ADO (providers), ODBC (drivers), or JDBC (drivers), rather than a database-specific ...