Developing .NET Web Services with XML
Write higher-level applications in less time using this hands-on guide, and learn the interrelated Web Services involved with .NET and XML.
TABLE OF CONTENTS Developing .NET Web Services with XML
Implementing the Jokes Data Repository
Now that the structure of the Jokes Web Service is firmly in place we can start the work of actual implementation. It is usually a good idea to start with the back end and spend a fair amount of time fleshing out the exact interface to store and retrieve data.
We will start off by installing the actual database system. We will then set up our data tables using a SQL installation script, before writing all the stored procedures needed to manage our jokes in the database.
| Warning | Later changes in methods exposed by the back end almost always require major rewrites of the whole application, so it really pays to be very careful when writing your back end methods. |
Installing the Database
The first step in working with a back end is of course to actually have a back end to work with Because we offer dynamic content, a simple flat file approach probably won t scale very well. Instead, let us use a relational database, such as SQL Server 2000. If you don t have a copy of this server, you re in luck, because the Microsoft .NET SDK actually comes with its own copy of Microsoft SQL Server Desktop Engine, a slightly scaled down version of the full server product, which is more than sufficient for our purposes. To install it, proceed as follows:
-
Open up %ProgramFiles%\Microsoft.NET\Microsoft.NET\_FrameworkSDK\Samples\setup\html\Start.htm.
-
Click on Step 1: Install the .NET Framework Samples Database and follow the instructions.
-
Verify in...
Copyright Syngress Publishing, Inc. 2002 under license agreement with Books24x7
