(c) 2002 Visual Studio Magazine 
Fawcette Technical Publications

Issue: July 2002
Section: Database Design
Authors: Greg Ewing, Jon Rauschenberger
Filename: vs0207dd

This articles code includes projects using the different data access APIs, as well as comparisons of each implementations performance and scalability. 

You can read about the scalability tests in the file sidebar.rtf.

You can find Listings 1, 2, and 3 in the listings.txt file.


To run these samples you will need to do the following:

.Net DBXML Project
1. Change the SERVERNAME variable in main.cs to your SQL server instance
2. If necessary change the two connection strings to use a uid and pwd instead of a trusted connection

VS6 Project
1. Change the connection string to the appropriate value
2. Compile the project
3. Create an application in COM+ services named VS6XMLTest
4. Add the DLL to your new COM+ application 

ASP.Net load test application
1. Create a new application in IIS named SqlXmlTestClient.  
2. Point the home directory for the application to the location of the source files
3. Change the ConnectionString in PerfTest.aspx.vb as appropriate

ASP (VS6 test) Project - Requires steps 3 and 4 from the VS6 project
1. Change the BasicConnectionString in Old.asp as appropriate
