| title | SQLXML 4.0 Data Access Components | ||||||
|---|---|---|---|---|---|---|---|
| description | Learn about the data access components in SQLXML 4.0 - SQLXMLOLEDB Provider, SQLXML Managed Classes, and the SQL Server Native Client (SQLNCLI11). | ||||||
| author | MikeRayMSFT | ||||||
| ms.author | mikeray | ||||||
| ms.date | 03/14/2017 | ||||||
| ms.service | sql | ||||||
| ms.subservice | xml | ||||||
| ms.topic | reference | ||||||
| helpviewer_keywords |
|
||||||
| monikerRange | =azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE SQL Server Azure SQL Database] [!INCLUDEmsCoName] SQLXML 4.0 includes three data providers that can insert XML data into and retrieve XML data from a database in [!INCLUDEssNoVersion]:
-
SQLXMLOLEDB Provider
Exposes SQLXML 4.0 functionality through ActiveX Data Objects (ADO).
-
SQLXML Managed Classes
Expose SQLXML functionality inside the [!INCLUDEmsCoName] .NET Framework. For more information, see SQLXML Managed Classes.
-
SQL Server Native Client (SQLNCLI11)
Exposes SQLXML 4.0 functionality through a new data access technology that extends and compliments current versions of Microsoft Data Access Components (MDAC). SQLNCLI11 provides full support for features introduced in [!INCLUDEssVersion2005]. For more information, see SQL Server Native Client Programming.