Export (0) Print
Expand All

Readme_ReviewWatcher

SQL Server 2005

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.

Application Area Features

Overall

SqlDependency

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.

To build the sample, do the following:

  1. Follow the steps in the readme.htm file for the Storefront sample application.

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

  3. Build the application in the solution file in the CS folder using Microsoft Visual Studio 2005 or MSBuild.

To run the sample, do the following:

  1. Browse to the Adventure Works Cycles Storefront sample by starting your Web browser and typing http://localhost/StoreCSVS/ in the Address bar.

  2. Using the category/subcategory tree control menu on the left, browse to a subcategory of a product, and then select the subcategory.

  3. Click a product in the list of products displayed.

  4. Using a file browser, locate and execute the ReviewWatcher.exe application, which is typically installed in bin\debug.

  5. Switch back to your Web browser, locate a particular product, and then click Review this Product.

  6. Fill in the text boxes and click Submit.

  7. A summary of the review should appear in the left pane in the ReviewWatcher application.

  8. Selecting the summary line in the left pane displays the contents of the review in the right pane.

To remove the sample, do the following:

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft