SQLXML 4.0 Data Access Components
Microsoft SQLXML 4.0 includes three data providers that can insert XML data into and retrieve XML data from a database in SQL Server:
Exposes SQLXML 4.0 functionality through ActiveX Data Objects (ADO).
SQLXML Managed Classes
Expose SQLXML functionality inside the Microsoft .NET Framework. For more information, see SQLXML Managed Classes.
SQL Server Native Client (SQLNCLI10)
Exposes SQLXML 4.0 functionality through a new data access technology that extends and compliments current versions of Microsoft Data Access Components (MDAC). SQLNCLI10 provides full support for features introduced in SQL Server 2005. For more information, see SQL Server 2008 R2 Native Client Programming.