📒
OpenRiaServices
  • Start
  • Prerequisites for Open Ria Services
    • Walkthrough: Installing and Configuring SQL Server 2008 R2 Express with Advanced Services
    • Walkthrough: Installing the AdventureWorks OLTP and LT sample databases
  • Creating Open Ria Services Solutions
    • Walkthrough: Taking a Tour of Open Ria Services
    • Walkthrough: Creating a Open Ria Services Solution
    • Walkthrough: Creating a Open Ria Service with the Code First Approach
    • Walkthrough: Using the Silverlight Business Application Template
    • Walkthrough: Creating a Open Ria Services Class Library
    • Walkthrough: Localizing a Business Application
    • How to: Create a Domain Service that uses POCO-defined Entities
    • How to: Add or Remove a Open Ria Services Link
    • Using the Domain Service Wizard
  • Building Secure Applications with Open Ria Services
  • Deploying and Localizing a Open Ria Services Solutions
    • Troubleshooting the Deployment of a Open Ria Services Solution
    • Troubleshooting the Deployment of a Open Ria Services Solution
    • Walkthrough: Localizing a Business Application
  • Middle Tier
    • Domain Services
      • Walkthrough: Adding Query Methods
      • How to: Add Business Logic to the Domain Service
      • How to: Create a Domain Service that uses POCO-defined Entities
      • How to: Use HTTPS with a Domain Service
    • Data
      • Compositional Hierarchies
      • Presentation Models
      • Inheritance in Data Models
      • Complex Types
      • Shared Entities
      • Walkthrough: Sharing Entities between Multiple Domain Services
      • How to: Add Metadata Classes
      • How to: Validate Data
      • Managing Data Concurrency
    • Shared Code
      • How to: Share Code through Source Files
      • Walkthrough: Creating a Open Ria Services Class Library
  • Silverlight Clients
    • Client Code Generation
    • DomainContext and Operations
    • DomainDataSource
    • Error Handling on the Client
    • Customizing Generated Code
      • How to: Add Computed Properties on the Client
  • Accessing non-Silverlight Clients
    • ASP.NET Clients
    • Walkthrough: Using the Domain Service in ASP.NET Applications
  • Authentication, Roles, and Profiles
    • How to: Enable Authentication in Open Ria Services
    • How to: Enable Roles in Open Ria Services
    • How to: Enable Profiles in Open Ria Services
    • How to: Create a Custom Authorization Attribute
    • Walkthrough: Using Authentication Service with Silverlight Business Application
    • Walkthrough: Using Authentication Service with Silverlight Navigation Application
  • End-to-EndScenarios
    • Walkthrough: Retrieving and Displaying Data From a Domain Service
    • Walkthrough: Editing Data From a Domain Service
    • Walkthrough: Displaying Data in a Silverlight Business Application
    • Walkthrough: Displaying Related Data in a Silverlight Business Application
Powered by GitBook
On this page
  • Installing the Adventure Works OLTP and LT Databases
  • To install the Adventure Works sample databases

Was this helpful?

  1. Prerequisites for Open Ria Services

Walkthrough: Installing the AdventureWorks OLTP and LT sample databases

PreviousWalkthrough: Installing and Configuring SQL Server 2008 R2 Express with Advanced ServicesNextCreating Open Ria Services Solutions

Last updated 4 years ago

Was this helpful?

[ This document was written for WCF Services Version 1 Service Pack 2 and might not be up to date Please see or for a list of changes since WCF RIA Services ]

The Open Ria Services walkthroughs assume that you have the AdventureWorks OLTP and LT databases installed. This walkthrough outlines the steps needed to create an instance of AdventureWorks OLTP and LT databases.

Important: Make sure you have a compatible installation of SQL Server 2008 R2 Express with Advanced Services or any retail version. The procedure for installing SQL Server 2008 R2 Express with Advanced Services is outlined in the topic.

Warning: Visual Studio, the Silverlight 4 Developer Runtime and SDK, and Open Ria Services and its Toolkit must also be installed to use the Open Ria Services walkthroughs. The installation points for these programs are provided in the topic.

Installing the Adventure Works OLTP and LT Databases

To install the Adventure Works sample databases

  1. Download the installer for

[!IMPORTANT] By default Windows Server 2008 security is configured to prevent the download of these installers. Changing the security configuration is not recommended on production servers. Please see the Windows Server documentation for information on how to change these settings.

  1. Run AdventureWorks2008R2_SR1.exe

  2. Click the I agree the license terms check box, then click the Next button.

  3. Select Run in the File Download window and then Yes in the User Account Control window when it appears.

  4. Use the pull down selector Installation Instance to choose the instance in which to install the databases from the Database Selection windows when it appears.

  5. While it is possible to change the directory where the scripts and data files will be installed, it is recommended that the default be used.

[!IMPORTANT] If the directory is changed, be sure that the account the SQL Server service runs under has read access to this directory.

  1. Ensure that boxes for installing the AdventureWorks OLTP 2008R2, AdventureWorks LT 2008R2, AdventureWorks OLTP, AdventureWorks LT databases are all checked. Leave the default for all other databases. Click the Install button.

  2. When the installation completes click the Finish button.

Release Notes
Changelog
Walkthrough: Installing and Configuring SQL Server 2008 R2 Express with Advanced Services
Prerequisites for Open Ria Services
AdventureWorks Sample Databases