Microsoft® .NET Compact Framework (Core Reference)
by Andy Wigley, Stephen Wheelwright, Robert Burbidge, Rory MacLoed, Mark Sutton
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access