Click here to Skip to main content
Click here to Skip to main content
Add your own
alternative version
Go to top

Building a 3-Tier App with Silverlight 3, .NET RIA Services, and Azure Table Storage

, 11 Jul 2009
This article presents the techniques and caveats of building a 3-tire Azure hosted application using Silverlight 3 (presentation tier), .NET RIA services (business logic and data access), and Windows Azure Table (data storage).
Azurelight_SourceCode.zip
Azurelight
Azure
DomainServices
Linq
Properties
StorageClient
Azurelight
Azurelight
Azurelight.ccproj
Azurelight_WebRole
ServiceConfiguration.cscfg
ServiceDefinition.csdef
Azurelight_WebRole
App_Data
Azurelight.mdf
Azurelight_log.ldf
App_GlobalResources
System.Web.Silverlight.dll
ClientBin
Global.asax
Model
Properties
Service
AzurelightNav
Command
Control
Generated_Code
Model
Properties
Resources
SilverlightCairngorm
Business
Command
Control
Model
Properties
Views
USE [master]
GO

/****** Object:  Database [Azurelight]    Script Date: 06/29/2009 20:26:55 ******/
CREATE DATABASE [Azurelight] ON  PRIMARY 
( NAME = N'Azurelight', FILENAME = N'.\Azurelight.mdf' , SIZE = 2304KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'Azurelight_log', FILENAME = N'.\Azurelight_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO

ALTER DATABASE [Azurelight] SET COMPATIBILITY_LEVEL = 100
GO

IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [Azurelight].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO

ALTER DATABASE [Azurelight] SET ANSI_NULL_DEFAULT OFF 
GO

ALTER DATABASE [Azurelight] SET ANSI_NULLS OFF 
GO

ALTER DATABASE [Azurelight] SET ANSI_PADDING OFF 
GO

ALTER DATABASE [Azurelight] SET ANSI_WARNINGS OFF 
GO

ALTER DATABASE [Azurelight] SET ARITHABORT OFF 
GO

ALTER DATABASE [Azurelight] SET AUTO_CLOSE ON 
GO

ALTER DATABASE [Azurelight] SET AUTO_CREATE_STATISTICS ON 
GO

ALTER DATABASE [Azurelight] SET AUTO_SHRINK OFF 
GO

ALTER DATABASE [Azurelight] SET AUTO_UPDATE_STATISTICS ON 
GO

ALTER DATABASE [Azurelight] SET CURSOR_CLOSE_ON_COMMIT OFF 
GO

ALTER DATABASE [Azurelight] SET CURSOR_DEFAULT  GLOBAL 
GO

ALTER DATABASE [Azurelight] SET CONCAT_NULL_YIELDS_NULL OFF 
GO

ALTER DATABASE [Azurelight] SET NUMERIC_ROUNDABORT OFF 
GO

ALTER DATABASE [Azurelight] SET QUOTED_IDENTIFIER OFF 
GO

ALTER DATABASE [Azurelight] SET RECURSIVE_TRIGGERS OFF 
GO

ALTER DATABASE [Azurelight] SET  ENABLE_BROKER 
GO

ALTER DATABASE [Azurelight] SET AUTO_UPDATE_STATISTICS_ASYNC OFF 
GO

ALTER DATABASE [Azurelight] SET DATE_CORRELATION_OPTIMIZATION OFF 
GO

ALTER DATABASE [Azurelight] SET TRUSTWORTHY OFF 
GO

ALTER DATABASE [Azurelight] SET ALLOW_SNAPSHOT_ISOLATION OFF 
GO

ALTER DATABASE [Azurelight] SET PARAMETERIZATION SIMPLE 
GO

ALTER DATABASE [Azurelight] SET READ_COMMITTED_SNAPSHOT OFF 
GO

ALTER DATABASE [Azurelight] SET HONOR_BROKER_PRIORITY OFF 
GO

ALTER DATABASE [Azurelight] SET  READ_WRITE 
GO

ALTER DATABASE [Azurelight] SET RECOVERY SIMPLE 
GO

ALTER DATABASE [Azurelight] SET  MULTI_USER 
GO

ALTER DATABASE [Azurelight] SET PAGE_VERIFY CHECKSUM  
GO

ALTER DATABASE [Azurelight] SET DB_CHAINING OFF 
GO

USE [Azurelight]
GO

/****** Object:  Table [dbo].[Surveys]    Script Date: 06/29/2009 20:31:18 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Surveys](
	[PartitionKey] [nvarchar](1000) NOT NULL,
	[RowKey] [nvarchar](1000) NOT NULL,
	[Timestamp] [datetime] NULL,
	[Target] [nvarchar](1000) NULL,
	[Rating] [int] NULL,
	[Comments] [nvarchar](1000) NULL,
 CONSTRAINT [PK_Surveys] PRIMARY KEY CLUSTERED 
(
	[PartitionKey] ASC,
	[RowKey] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Common Development and Distribution License (CDDL)

Share

About the Author

Modesty Zhang
Technical Lead
United States United States
Tech Lead of large scale consumer facing software offerings, specializing in Web and Mobile application architecting and development.
 
Specialties:
Web App/ iOS / Cocoa Touch / HTML5 / CSS3 / Ajax / jQuery / jQuery Mobile / jQuery UI / Node.js / Rich JavaScript Application / RESTful Web Services / Java EE 6 / Java 7 / PHP / Ruby on Rails / and Windows / .NET / RIA / Flex / Flash / Silverlight / Software Architecting / Front End Design and Development

| Advertise | Privacy | Mobile
Web01 | 2.8.140916.1 | Last Updated 12 Jul 2009
Article Copyright 2009 by Modesty Zhang
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid