sqlxml-managed-classes-sqlxmladapter-object.md

title	SqlXmlAdapter Object (SQLXML)
description	Learn about the SqlXmlAdapter object that provides methods that facilitate interaction with the dataset in the .NET Framework.
author	MikeRayMSFT
ms.author	mikeray
ms.date	03/16/2017
ms.service	sql
ms.subservice	xml
ms.topic	reference
helpviewer_keywords	void Update(DataSet ds) method SqlXmlAdapter object void Fill(DataSet ds) method SQLXML Managed Classes, SqlXmlAdapter object Managed Classes [SQLXML], SqlXmlAdapter object
monikerRange	=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current
ms.custom	sfi-ropc-nochange

SQLXML Managed Classes - SqlXmlAdapter Object

[!INCLUDE SQL Server Azure SQL Database] This object provides methods that facilitate interaction with the dataset in the [!INCLUDEmsCoName] .NET Framework. For a working sample, see Accessing SQLXML Functionality in the .NET Environment.

The SqlXmlAdapter object supports these methods:

void Fill(DataSet ds)
Fills the dataset in the .NET Framework with the XML data retrieved from [!INCLUDEssNoVersion].

void Update(DataSet ds)
Applies updates to records in [!INCLUDEssNoVersion] from the data in the dataset.

The SqlXmlAdapter object supports these constructors:

public SqlXmlAdapter(SqlXmlCommand  cmd)   
  
public SqlXmlAdapter(  
                     string commandText,   
                     SqlXmlCommandType cmdType,   
                     string connectionString  
                      )   
  
public SqlXmlAdapter(  
                     Stream commandStream,   
                     SqlXmlCommandType cmdType,   
                     string connectionString  
                     )   

See Also

SqlXmlCommand Object (SQLXML Managed Classes)
SqlXmlParameter Object (SQLXML Managed Classes)