Using XML in the .NET Enterprise Servers

Chapter 18

Using XML in the .NET Enterprise Servers

IN THIS CHAPTER

• BizTalk

• SQL Server 2000

Microsoft has invested a considerable amount of time and energy into creating a com-plete series of components that will easily integrate together to solve many of the problems currently faced by businesses. In addition to Visual Studio .NET, Microsoft produces a set of “enterprise servers”: BizTalk Server 2000 and SQL Server 2000, both of which are designed to “Web-enable” various enterprise aspects of companies. Everything from Business-to-Business communication and Business-to-Consumer com-munication to publishing real-time data on the Web. In addition, the .NET Enterprise Servers are designed to help build, deploy, and manage these Web-enabling solutions.

BizTalk Server is geared toward handling Business-to-Business (B2B) communication in an automated fashion, whereas SQL Server 2000 is Microsoft’s answer to a database management system that handles scalability. In this chapter, you’ll learn

   About the basic concepts of BizTalk Server 2000

   How to route documents in BizTalk Server 2000

   About the new For  XML clause in SQL Server 2000

   How to query SQL Server 2000 using a URL query

   How to query SQL Server 2000 using a template query

   How to create annotated XSD schemas

   How to query SQL Server 2000 using an XPath query

   How to create XML updategrams

   How to submit XML updategrams to SQL Server 2000