O'Reilly logo

A Developer’s Guide to SQL Server 2005 by Dan Sullivan, Bob Beauchemin

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

13. SQL Server 2005 and Clients

WITH THE ADVENT OF CLR user-defined types, as well as improved large value type data support, XML support, and other SQL Server engine features, comes enhancement of the client APIs. This chapter looks at the enhancements to the ADO.NET client libraries as well as the classic data access APIs—OLE DB, ADO, and ODBC—to support new SQL Server 2005 features.

SQL Native Client

SQL Server ships with support for four main data access APIs currently used in client-side programming:

• ADO.NET

• OLE DB and ADO

• ODBC

• JDBC

ADO.NET is the managed data access layer for the .NET Framework. If you’re using the .NET Framework in your client-side code, the ADO.NET data provider, System.Data.SqlClient, is your best choice. It ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required