O'Reilly logo

Applied XML Programming for Microsoft® .NET by Dino Esposito

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required