Microsoft® .NET Compact Framework (Core Reference)

SQLXML

So far, this chapter has looked in detail at how to extract and update relational data from a SQL Server data source using the System.Data.SqlClient objects. You’ve seen how the data can be read into a DataSet (from where it can be represented) or saved locally as XML. At this stage, you should be aware that an alternative route called SQLXML exists for XML data when using SQL Server as the data source. SQLXML enables developers to bridge the gap between XML and relational data.

Using SQLXML, you can

• Create XML views of existing relational data, and work with them as if they were XML files.

• Query SQL Server relational data using XPath, via a URL on the Web browser, or from a Web application.

• Query relational data with SQL, and return results ...