Conclusion
In this chapter, we have explored the connections between databases (SQL Server 2000 in particular) and XML. Several DBMS systems provide XML support in various forms. The industry standard, however, requires that a DBMS provide for direct XML result sets and accept changes expressed as XML streams. SQL Server 2000 adheres to these requirements.
The difficulty lies in .NET and the different connecting model it introduces—.NET Framework data providers instead of OLE DB providers. For .NET Framework applications, fetching data as XML is much easier and more effective than persisting changes as XML. For COM applications, the same features are more balanced. The reason is that SQL Server 2000 came out much earlier than the .NET Framework, ...
Get Applied XML Programming for Microsoft® .NET now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
