XML Data in SQL Server (ADO.NET)
SQL Server 2005 exposes the functionality of SQLXML inside the .NET Framework. Developers can write applications that access XML data from an instance of SQL Server, bring the data into the .NET Framework environment, process the data, and send the updates back to SQL Server. XML data can be used in several ways in SQL Server 2005, including data storage, and as parameter values for retrieving data. The SqlXml class in the .NET Framework provides the client-side support for working with data stored in an XML column within SQL Server 2005. For more information, see "SQLXML Managed Classes" in SQL Server Books Online.
In This Section
SQL XML Column Values (ADO.NET)
Demonstrates how to retrieve and work with XML data retrieved from SQL Server 2005.Specifying XML Values as Parameters (ADO.NET)
Demonstrates how to pass XML data as a parameter to a command.XML Data in SQL Server 2000 (ADO.NET)
Describes how to obtain an XML stream from a SQL Server 2000 database.