Programming SQL Server 2005

Chapter 6. .NET Client-Side Programming

This chapter describes SQL Server 2005 client-side programming technologies. These include:

SQL Native Client programming

Replaces the SQL OLE DB and SQL ODBC drivers; uses Microsoft Data Access Components (MDAC) and implements functionality supporting new features in SQL Server 2005.

SQLXML 4.0

Updates SQLXML 3.0 to accommodate new features in SQL Server 2005.

Exception Message Box programming

Extends the functionality of the regular message box in the System.Windows.Forms.MessageBox class to make it easier for you to control and to provide detailed information to users.

SQL Native Client Programming

Microsoft SQL Server 2005 introduces SQL Native Client, which is designed to simplify native access to data in SQL Server 7.0 or later using either OLE DB or ODBC. SQL Native Client replaces the SQL OLE DB provider and the SQL ODBC driver with a standalone API that combines both the SQL OLE DB provider and SQL ODBC driver functionality into a single DLL. The individual data access technologies are now referred to as SQL Native Client (OLE DB) and SQL Native Client (ODBC). Additionally, SQL Native Client supports new SQL Server 2005 enhancements, as described in Table 6-1.

Table 6-1. SQL Native Client support for new functionality in SQL Server 2005 (continued)

Function	Description
xml data type	Supports the SQL Server 2005 xml data type for columns, variable, parameters, and return types
Large value types	Supports SQL Server large-object data ...