XML and the SQL 2000 Server, Part 4: Introducing SqlXml 3.0 - Enter SQLXML 3.0
(Page 3 of 9 )
In early Jan 2002, with SQLXML3.0 release, a number of additional functionalities for XML support of SQL 2000 were introduced. Briefly, the following additional features were added, but in this tutorial we look mainly at data access using SQLXML3.0 with the Visual Studio .NET 2003 IDE.
- Web Services (SOAP) Support
- Client-side FOR XML
Server processed queries were xml formatted on client side - XML Schema Definition language (XSD)
Create XML view of relational data - Updategrams
DML procedures with an UpdateGram - Bulk Loading XML data
- Support for Microsoft .NET Framework
SQLXML Managed Classes can be referenced from within
Microsoft .NET Framework.
The DiffGram format is supported.
XML data access using SqlXmlCommand Class
SQLXML 3.0 provide support for applications to access XML data from an instance of SQL 2000 server, port the data to the Microsoft.NET environment,process data, and send back the data to the SQL Server. These are effectively carried out obtaining support from the Microsoft Managed Classes. When SQLXML3.0 is installed, the Microsoft.Data.SqlXml libararies can be accessed from the application by adding a reference. In the codes that follow, the imports statement would make a reference to Microsoft.Data.SQLXml. The SQLXML managed classes object model has the following objects, of which the SqlXmlCommand class will be explored in detail.
- SqlXmlCommand
- SqlXmlParameter
- SqlXmlAdapter
Properties and methods supported by the SqlXmlCommand[Microsoft.Data.SqlXml.SqlXmlCommand] object are shown followed by the ADO.NET's SQLCommand [System.Data.SqlClient.SqlCommand]object in the next two pictures. A number of methods and properties[red rectangles in sqlxmlcommand object] add a great deal of support for XML based applications.The SqlXmlCommand class will be explored in detail with concrete examples.
Analogous to the SQLCommand's CommandType, there is a SQLXMLCommand's CommandType, notice the differences in the pictures shown. It is clear that, if SqlCommand is tailored for relational data, SqlXmlCommand is well suited for handling XML.
Next: Exploring the SqlXmlCommand Class >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
