EXPERT RESPONSE
The SQL Native Client is a new OLE DB and ODBC API that provides data access providers with new functionality and datatypes provided by SQL Server 2005. By using SQL Native Client, applications can make use of features such as Multiple Active Result Sets (MARS), SQL Server 2005's XML datatype and CLR user-defined datatypes, and SQL Service Broker.
Developers using .NET languages such as C# or VB.NET in conjunction with ADO.NET will not need to worry about the SQL Native Client—all of the features it exposes are present in the ADO.NET classes. However, developers programming COM-based applications that need to access SQL Server 2005 databases may wish to expand their functionality by using the SQL Native Client for data access.
Do you have comments on this Ask the Expert Q&A? Let us know.
|
