The Adventure Works Cycles ReviewWatcher sample for SQL Server 2005 demonstrates how to use query notifications. This sample is used in conjunction with the Adventure Works Cycles Storefront e-commerce sample application. This document describes how to install the SQL Server 2005 version of the ReviewWatcher sample application.
This sample works with the SQL Server 2005 version of the AdventureWorks sample database.
This sample requires administrator privileges on the server to run correctly.
The default installation directory is drive:\Program Files\Microsoft SQL Server\90\Samples\Integrated Samples\Storefront\CS\ReviewWatcher\.
A developer is trying to build an application that displays changes to the database as they happen, without polling the database.
Transact-SQL, Visual C#, and Visual Basic.
The ReviewWatcher sample uses the following features of SQL Server 2005.
Before running this sample, make sure the following software is installed:
- SQL Server 2005, including the following components:
- SQL Server Database Engine
- SQL Server Management Studio
- AdventureWorks sample database available at the CodePlex web site.
- Database Engine Samples available at the CodePlex web site.
- .NET Framework SDK 2.0 or Microsoft Visual Studio 2005. You can obtain .NET Framework SDK free of charge. See Installing the .NET Framework SDK.
Building the Sample
To build the sample, do the following:
Build the sample
Follow the steps in the readme.htm file for the Storefront sample application.
Note that in SQL Server 2005, Service Broker is disabled in the AdventureWorks database. It must be enabled by using the following script for this sample to operate correctly:
ALTER DATABASE AdventureWorks SET ENABLE_BROKER
Build the application in the solution file in the CS folder using Microsoft Visual Studio 2005 or MSBuild.
Running the Sample
To run the sample, do the following:
Run the sample
Browse to the Adventure Works Cycles Storefront sample by starting your Web browser and typing http://localhost/StoreCSVS/ in the Address bar.
Using the category/subcategory tree control menu on the left, browse to a subcategory of a product, and then select the subcategory.
Click a product in the list of products displayed.
Using a file browser, locate and execute the ReviewWatcher.exe application, which is typically installed in bin\debug.
Switch back to your Web browser, locate a particular product, and then click Review this Product.
Fill in the text boxes and click Submit.
A summary of the review should appear in the left pane in the ReviewWatcher application.
Selecting the summary line in the left pane displays the contents of the review in the right pane.
Removing the Sample
To remove the sample, do the following:
Remove the sample
- Follow the instructions for removing the Storefront sample located in the Readme file for that sample.
The common language runtime for SQL Server 2005 must be enabled for this sample to work correctly.