Readme_ReviewWatcher

  • Article

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

This sample works only with SQL Server 2005 and SQL Server 2008. It will not work with any version of SQL Server earlier than SQL Server 2005.

The Adventure Works Cycles ReviewWatcher sample for SQL Server 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 version of the ReviewWatcher sample application.

This sample requires administrator privileges on the server to run correctly.

The default installation directory is C:\Program Files\Microsoft SQL Server\100\Samples\Integrated Samples\Storefront\CS\ReviewWatcher\.

Scenario

A developer is trying to build an application that displays changes to the database as they happen, without polling the database.

Languages

Transact-SQL, Visual C#, and Visual Basic.

Features

The ReviewWatcher sample uses the following features of SQL Server.

Application Area Features

Overall

SqlDependency

Prerequisites

Before running this sample, make sure the following software is installed:

  • SQL Server, including the following components:
    • SQL Server Database Engine
    • SQL Server Management Studio
    • AdventureWorks2008R2 sample database which is available at the CodePlex Web site.
    • Database Engine Samples which are 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 Documentation.

Building the Sample

To build the sample, do the following:

Build the sample

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

  2. Note that in SQL Server, Service Broker is disabled in the AdventureWorks2008R2 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.

Running the Sample

To run the sample, do the following:

Run the sample

  1. Browse to the Adventure Works Cycles Storefront sample by starting your Web browser and typing https://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.

Removing the Sample

To remove the sample, do the following:

Remove the sample

  1. Follow the instructions for removing the Storefront sample located in the Readme file for that sample.

Comments

The common language runtime for SQL Server must be enabled for this sample to work correctly.

See Also

Concepts

SQL Server End-to-End Samples

Help and Information

Getting SQL Server 2008 R2 Assistance