Migrating MVC Apps to the Cloud

Article
11/24/2010

Support for Screencast under development

This blog post is providing snippets for a screencast under development. It will grow in size and will include video downloads, with full source.

Beginning Source Code Snippets

Snippet – Create database

View and download create database script

 USE [master]
 GO
 /****** Object:  Database [MarketIndexData]    Script Date: 11/24/2010 13:37:40 ******/
 CREATE DATABASE [MarketIndexData] ON  PRIMARY 
 ( NAME = N'MarketIndexData', FILENAME = N'C:\databases\MarketIndexData.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
  LOG ON 
 ( NAME = N'MarketIndexData_log', FILENAME = N'C:\databases\MarketIndexData_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
 GO
 ALTER DATABASE [MarketIndexData] SET COMPATIBILITY_LEVEL = 100
 GO
 IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
 begin
 EXEC [MarketIndexData].[dbo].[sp_fulltext_database] @action = 'enable'
 end
 GO
 ALTER DATABASE [MarketIndexData] SET ANSI_NULL_DEFAULT OFF
 GO
 ALTER DATABASE [MarketIndexData] SET ANSI_NULLS OFF
 GO
 ALTER DATABASE [MarketIndexData] SET ANSI_PADDING OFF
 GO
 ALTER DATABASE [MarketIndexData] SET ANSI_WARNINGS OFF
 GO
 ALTER DATABASE [MarketIndexData] SET ARITHABORT OFF
 GO
 ALTER DATABASE [MarketIndexData] SET AUTO_CLOSE OFF
 GO
 ALTER DATABASE [MarketIndexData] SET AUTO_CREATE_STATISTICS ON
 GO
 ALTER DATABASE [MarketIndexData] SET AUTO_SHRINK OFF
 GO
 ALTER DATABASE [MarketIndexData] SET AUTO_UPDATE_STATISTICS ON
 GO
 ALTER DATABASE [MarketIndexData] SET CURSOR_CLOSE_ON_COMMIT OFF
 GO
 ALTER DATABASE [MarketIndexData] SET CURSOR_DEFAULT  GLOBAL
 GO
 ALTER DATABASE [MarketIndexData] SET CONCAT_NULL_YIELDS_NULL OFF
 GO
 ALTER DATABASE [MarketIndexData] SET NUMERIC_ROUNDABORT OFF
 GO
 ALTER DATABASE [MarketIndexData] SET QUOTED_IDENTIFIER OFF
 GO
 ALTER DATABASE [MarketIndexData] SET RECURSIVE_TRIGGERS OFF
 GO
 ALTER DATABASE [MarketIndexData] SET  DISABLE_BROKER
 GO
 ALTER DATABASE [MarketIndexData] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
 GO
 ALTER DATABASE [MarketIndexData] SET DATE_CORRELATION_OPTIMIZATION OFF
 GO
 ALTER DATABASE [MarketIndexData] SET TRUSTWORTHY OFF
 GO
 ALTER DATABASE [MarketIndexData] SET ALLOW_SNAPSHOT_ISOLATION OFF
 GO
 ALTER DATABASE [MarketIndexData] SET PARAMETERIZATION SIMPLE
 GO
 ALTER DATABASE [MarketIndexData] SET READ_COMMITTED_SNAPSHOT OFF
 GO
 ALTER DATABASE [MarketIndexData] SET HONOR_BROKER_PRIORITY OFF
 GO
 ALTER DATABASE [MarketIndexData] SET  READ_WRITE
 GO
 ALTER DATABASE [MarketIndexData] SET RECOVERY FULL
 GO
 ALTER DATABASE [MarketIndexData] SET  MULTI_USER
 GO
 ALTER DATABASE [MarketIndexData] SET PAGE_VERIFY CHECKSUM
 GO
 ALTER DATABASE [MarketIndexData] SET DB_CHAINING OFF
 GO
 EXEC sys.sp_db_vardecimal_storage_format N'MarketIndexData', N'ON'
 GO
 USE [MarketIndexData]
 GO
 /****** Object:  Table [dbo].[Assets]    Script Date: 11/24/2010 13:37:42 ******/
 SET ANSI_NULLS ON
 GO
 SET QUOTED_IDENTIFIER ON
 GO
 CREATE TABLE [dbo].[Assets](
     [AssetID] [nchar](16) NOT NULL,
     [Description] [nvarchar](max) NOT NULL,
  CONSTRAINT [PK_Assets] PRIMARY KEY CLUSTERED 
 (
     [AssetID] 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
 INSERT [dbo].[Assets] ([AssetID], [Description]) VALUES (N'DJ              ', N'Dow Jones Industrials Index')
 INSERT [dbo].[Assets] ([AssetID], [Description]) VALUES (N'EUROSTOXX       ', N'EuroZone Index')
 INSERT [dbo].[Assets] ([AssetID], [Description]) VALUES (N'SP500           ', N'Standard & Poors 500 Stock Market Index')
 /****** Object:  Table [dbo].[AssetPrices]    Script Date: 11/24/2010 13:37:42 ******/
 SET ANSI_NULLS ON
 GO
 SET QUOTED_IDENTIFIER ON
 GO
 CREATE TABLE [dbo].[AssetPrices](
     [AssetPricesId] [int] IDENTITY(1,1) NOT NULL,
     [AssetID] [nchar](16) NULL,
     [DatePrice] [smalldatetime] NOT NULL,
     [OpenPrice] [real] NOT NULL,
  CONSTRAINT [PK_AssetPrices] PRIMARY KEY CLUSTERED 
 (
     [AssetPricesId] 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
 SET IDENTITY_INSERT [dbo].[AssetPrices] ON
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (1, N'SP500           ', CAST(0x9DB50000 AS SmallDateTime), 1077.23)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (2, N'SP500           ', CAST(0x9DAE0000 AS SmallDateTime), 1022.58)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (3, N'SP500           ', CAST(0x9DA70000 AS SmallDateTime), 1077.5)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (4, N'SP500           ', CAST(0x9DA00000 AS SmallDateTime), 1122.79)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (5, N'SP500           ', CAST(0x9D990000 AS SmallDateTime), 1095)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (6, N'SP500           ', CAST(0x9D920000 AS SmallDateTime), 1065.84)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (7, N'SP500           ', CAST(0x9D8B0000 AS SmallDateTime), 1089.41)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (8, N'SP500           ', CAST(0x9D840000 AS SmallDateTime), 1084.78)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (9, N'SP500           ', CAST(0x9D7D0000 AS SmallDateTime), 1136.52)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (10, N'SP500           ', CAST(0x9D760000 AS SmallDateTime), 1122.27)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (11, N'SP500           ', CAST(0x9D6F0000 AS SmallDateTime), 1188.57)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (12, N'SP500           ', CAST(0x9D680000 AS SmallDateTime), 1217.06)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (13, N'SP500           ', CAST(0x9D610000 AS SmallDateTime), 1192.06)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (14, N'SP500           ', CAST(0x9D5A0000 AS SmallDateTime), 1194.93)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (15, N'SP500           ', CAST(0x9D530000 AS SmallDateTime), 1178.71)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (16, N'SP500           ', CAST(0x9D4B0000 AS SmallDateTime), 1167.7)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (17, N'SP500           ', CAST(0x9D450000 AS SmallDateTime), 1157.25)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (18, N'SP500           ', CAST(0x9D3E0000 AS SmallDateTime), 1148.53)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (19, N'SP500           ', CAST(0x9D370000 AS SmallDateTime), 1138.4)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (20, N'SP500           ', CAST(0x9D300000 AS SmallDateTime), 1105.36)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (21, N'SP500           ', CAST(0x9D290000 AS SmallDateTime), 1110)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (22, N'SP500           ', CAST(0x9D220000 AS SmallDateTime), 1075.51)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (23, N'SP500           ', CAST(0x9D1B0000 AS SmallDateTime), 1065.51)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (24, N'SP500           ', CAST(0x9D140000 AS SmallDateTime), 1073.89)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (25, N'SP500           ', CAST(0x9D0D0000 AS SmallDateTime), 1092.4)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (26, N'SP500           ', CAST(0x9D060000 AS SmallDateTime), 1136.03)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (27, N'SP500           ', CAST(0x9CFF0000 AS SmallDateTime), 1145.96)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (28, N'SP500           ', CAST(0x9CF80000 AS SmallDateTime), 1116.56)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (29, N'SP500           ', CAST(0x9CF00000 AS SmallDateTime), 1127.5)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (30, N'SP500           ', CAST(0x9CE90000 AS SmallDateTime), 1105.31)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (31, N'SP500           ', CAST(0x9CE30000 AS SmallDateTime), 1107.84)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (32, N'SP500           ', CAST(0x9CDC0000 AS SmallDateTime), 1105.52)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (33, N'SP500           ', CAST(0x9CD50000 AS SmallDateTime), 1091.06)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (34, N'SP500           ', CAST(0x9CCE0000 AS SmallDateTime), 1094.86)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (35, N'SP500           ', CAST(0x9CC70000 AS SmallDateTime), 1094.13)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (36, N'SP500           ', CAST(0x9CC00000 AS SmallDateTime), 1072.31)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (37, N'SP500           ', CAST(0x9CB90000 AS SmallDateTime), 1036.18)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (38, N'SP500           ', CAST(0x9CB20000 AS SmallDateTime), 1080.36)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (39, N'SP500           ', CAST(0x9CAB0000 AS SmallDateTime), 1088.22)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (40, N'SP500           ', CAST(0x9CA40000 AS SmallDateTime), 1071.63)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (41, N'SP500           ', CAST(0x9C9D0000 AS SmallDateTime), 1026.87)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (42, N'SP500           ', CAST(0x9C960000 AS SmallDateTime), 1045.38)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (43, N'SP500           ', CAST(0x9C8F0000 AS SmallDateTime), 1067.14)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (44, N'SP500           ', CAST(0x9C880000 AS SmallDateTime), 1040.15)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (45, N'SP500           ', CAST(0x9C810000 AS SmallDateTime), 1018.67)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (46, N'SP500           ', CAST(0x9C7A0000 AS SmallDateTime), 1025.21)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (47, N'SP500           ', CAST(0x9C730000 AS SmallDateTime), 1026.59)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (48, N'SP500           ', CAST(0x9C6C0000 AS SmallDateTime), 998.18)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (49, N'SP500           ', CAST(0x9C650000 AS SmallDateTime), 1008.89)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (50, N'SP500           ', CAST(0x9C5E0000 AS SmallDateTime), 990.22)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (51, N'SP500           ', CAST(0x9C570000 AS SmallDateTime), 978.63)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (52, N'SP500           ', CAST(0x9C500000 AS SmallDateTime), 942.07)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (53, N'DJ              ', CAST(0x9DB50000 AS SmallDateTime), 10199.24)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (54, N'DJ              ', CAST(0x9DAE0000 AS SmallDateTime), 9686.48)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (55, N'DJ              ', CAST(0x9DA70000 AS SmallDateTime), 10143.05)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (56, N'DJ              ', CAST(0x9DA00000 AS SmallDateTime), 10452.46)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (57, N'DJ              ', CAST(0x9D990000 AS SmallDateTime), 10211.83)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (58, N'DJ              ', CAST(0x9D920000 AS SmallDateTime), 9931.75)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (59, N'DJ              ', CAST(0x9D8B0000 AS SmallDateTime), 10136.63)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (60, N'DJ              ', CAST(0x9D840000 AS SmallDateTime), 10193.46)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (61, N'DJ              ', CAST(0x9D7D0000 AS SmallDateTime), 10616.98)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (62, N'DJ              ', CAST(0x9D760000 AS SmallDateTime), 10386.18)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (63, N'DJ              ', CAST(0x9D6F0000 AS SmallDateTime), 11009.6)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (64, N'DJ              ', CAST(0x9D680000 AS SmallDateTime), 11205.11)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (65, N'DJ              ', CAST(0x9D610000 AS SmallDateTime), 11018.36)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (66, N'DJ              ', CAST(0x9D5A0000 AS SmallDateTime), 10996.75)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (67, N'DJ              ', CAST(0x9D530000 AS SmallDateTime), 10927.45)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (68, N'DJ              ', CAST(0x9D4B0000 AS SmallDateTime), 10849.23)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (69, N'DJ              ', CAST(0x9D450000 AS SmallDateTime), 10741)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (70, N'DJ              ', CAST(0x9D3E0000 AS SmallDateTime), 10623.41)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (71, N'DJ              ', CAST(0x9D370000 AS SmallDateTime), 10563.78)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (72, N'DJ              ', CAST(0x9D300000 AS SmallDateTime), 10326.1)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (73, N'DJ              ', CAST(0x9D290000 AS SmallDateTime), 10402.43)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (74, N'DJ              ', CAST(0x9D220000 AS SmallDateTime), 10099.14)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (75, N'DJ              ', CAST(0x9D1B0000 AS SmallDateTime), 10005.43)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (76, N'DJ              ', CAST(0x9D140000 AS SmallDateTime), 10068.99)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (77, N'DJ              ', CAST(0x9D0D0000 AS SmallDateTime), 10175.1)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (78, N'DJ              ', CAST(0x9D060000 AS SmallDateTime), 10609.65)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (79, N'DJ              ', CAST(0x9CFF0000 AS SmallDateTime), 10620.31)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (80, N'DJ              ', CAST(0x9CF80000 AS SmallDateTime), 10430.69)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (81, N'DJ              ', CAST(0x9CF00000 AS SmallDateTime), 10517.91)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (82, N'DJ              ', CAST(0x9CE90000 AS SmallDateTime), 10330.1)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (83, N'DJ              ', CAST(0x9CE30000 AS SmallDateTime), 10471.28)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (84, N'DJ              ', CAST(0x9CDC0000 AS SmallDateTime), 10386.86)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (85, N'DJ              ', CAST(0x9CD50000 AS SmallDateTime), 10309.77)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (86, N'DJ              ', CAST(0x9CCE0000 AS SmallDateTime), 10320.13)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (87, N'DJ              ', CAST(0x9CC70000 AS SmallDateTime), 10267.53)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (88, N'DJ              ', CAST(0x9CC00000 AS SmallDateTime), 10020.62)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (89, N'DJ              ', CAST(0x9CB90000 AS SmallDateTime), 9712.13)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (90, N'DJ              ', CAST(0x9CB20000 AS SmallDateTime), 9972.33)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (91, N'DJ              ', CAST(0x9CAB0000 AS SmallDateTime), 9996.67)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (92, N'DJ              ', CAST(0x9CA40000 AS SmallDateTime), 9865.24)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (93, N'DJ              ', CAST(0x9C9D0000 AS SmallDateTime), 9488.73)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (94, N'DJ              ', CAST(0x9C960000 AS SmallDateTime), 9663.23)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (95, N'DJ              ', CAST(0x9C8F0000 AS SmallDateTime), 9818.61)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (96, N'DJ              ', CAST(0x9C880000 AS SmallDateTime), 9598.08)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (97, N'DJ              ', CAST(0x9C810000 AS SmallDateTime), 9441.27)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (98, N'DJ              ', CAST(0x9C7A0000 AS SmallDateTime), 9542.91)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (99, N'DJ              ', CAST(0x9C730000 AS SmallDateTime), 9506.18)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (100, N'DJ              ', CAST(0x9C6C0000 AS SmallDateTime), 9313.85)
 GO
 print 'Processed 100 total records'
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (101, N'DJ              ', CAST(0x9C650000 AS SmallDateTime), 9368.41)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (102, N'DJ              ', CAST(0x9C5E0000 AS SmallDateTime), 9173.65)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (103, N'DJ              ', CAST(0x9C570000 AS SmallDateTime), 9093.09)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (104, N'DJ              ', CAST(0x9C500000 AS SmallDateTime), 8746.05)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (105, N'EUROSTOXX       ', CAST(0x9DB50000 AS SmallDateTime), 33.23)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (106, N'EUROSTOXX       ', CAST(0x9DAE0000 AS SmallDateTime), 30.87)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (107, N'EUROSTOXX       ', CAST(0x9DA70000 AS SmallDateTime), 32.16)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (108, N'EUROSTOXX       ', CAST(0x9DA00000 AS SmallDateTime), 33.87)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (109, N'EUROSTOXX       ', CAST(0x9D990000 AS SmallDateTime), 33)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (110, N'EUROSTOXX       ', CAST(0x9D920000 AS SmallDateTime), 30.72)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (111, N'EUROSTOXX       ', CAST(0x9D8B0000 AS SmallDateTime), 32.22)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (112, N'EUROSTOXX       ', CAST(0x9D840000 AS SmallDateTime), 31.77)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (113, N'EUROSTOXX       ', CAST(0x9D7D0000 AS SmallDateTime), 32.98)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (114, N'EUROSTOXX       ', CAST(0x9D760000 AS SmallDateTime), 35.08)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (115, N'EUROSTOXX       ', CAST(0x9D6F0000 AS SmallDateTime), 36.77)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (116, N'EUROSTOXX       ', CAST(0x9D680000 AS SmallDateTime), 38.56)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (117, N'EUROSTOXX       ', CAST(0x9D610000 AS SmallDateTime), 38.75)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (118, N'EUROSTOXX       ', CAST(0x9D5A0000 AS SmallDateTime), 40)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (119, N'EUROSTOXX       ', CAST(0x9D530000 AS SmallDateTime), 39.91)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (120, N'EUROSTOXX       ', CAST(0x9D4B0000 AS SmallDateTime), 38.89)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (121, N'EUROSTOXX       ', CAST(0x9D450000 AS SmallDateTime), 37.94)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (122, N'EUROSTOXX       ', CAST(0x9D3E0000 AS SmallDateTime), 38.88)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (123, N'EUROSTOXX       ', CAST(0x9D370000 AS SmallDateTime), 38.76)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (124, N'EUROSTOXX       ', CAST(0x9D300000 AS SmallDateTime), 36.77)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (125, N'EUROSTOXX       ', CAST(0x9D290000 AS SmallDateTime), 37.32)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (126, N'EUROSTOXX       ', CAST(0x9D220000 AS SmallDateTime), 36.04)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (127, N'EUROSTOXX       ', CAST(0x9D1B0000 AS SmallDateTime), 35.8)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (128, N'EUROSTOXX       ', CAST(0x9D140000 AS SmallDateTime), 38.21)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (129, N'EUROSTOXX       ', CAST(0x9D0D0000 AS SmallDateTime), 39.27)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (130, N'EUROSTOXX       ', CAST(0x9D060000 AS SmallDateTime), 41.63)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (131, N'EUROSTOXX       ', CAST(0x9CFF0000 AS SmallDateTime), 43.3)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (132, N'EUROSTOXX       ', CAST(0x9CF80000 AS SmallDateTime), 42.48)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (133, N'EUROSTOXX       ', CAST(0x9CF00000 AS SmallDateTime), 42.38)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (134, N'EUROSTOXX       ', CAST(0x9CE90000 AS SmallDateTime), 40.8)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (135, N'EUROSTOXX       ', CAST(0x9CE30000 AS SmallDateTime), 41.84)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (136, N'EUROSTOXX       ', CAST(0x9CDC0000 AS SmallDateTime), 42.29)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (137, N'EUROSTOXX       ', CAST(0x9CD50000 AS SmallDateTime), 41.63)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (138, N'EUROSTOXX       ', CAST(0x9CCE0000 AS SmallDateTime), 42.52)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (139, N'EUROSTOXX       ', CAST(0x9CC70000 AS SmallDateTime), 43.08)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (140, N'EUROSTOXX       ', CAST(0x9CC00000 AS SmallDateTime), 41.8)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (141, N'EUROSTOXX       ', CAST(0x9CB90000 AS SmallDateTime), 39.89)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (142, N'EUROSTOXX       ', CAST(0x9CB20000 AS SmallDateTime), 42.7)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (143, N'EUROSTOXX       ', CAST(0x9CAB0000 AS SmallDateTime), 43.1)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (144, N'EUROSTOXX       ', CAST(0x9CA40000 AS SmallDateTime), 42.37)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (145, N'EUROSTOXX       ', CAST(0x9C9D0000 AS SmallDateTime), 39.84)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (146, N'EUROSTOXX       ', CAST(0x9C960000 AS SmallDateTime), 41.25)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (147, N'EUROSTOXX       ', CAST(0x9C8F0000 AS SmallDateTime), 41.19)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (148, N'EUROSTOXX       ', CAST(0x9C880000 AS SmallDateTime), 40.37)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (149, N'EUROSTOXX       ', CAST(0x9C810000 AS SmallDateTime), 40.05)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (150, N'EUROSTOXX       ', CAST(0x9C7A0000 AS SmallDateTime), 39.21)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (151, N'EUROSTOXX       ', CAST(0x9C730000 AS SmallDateTime), 39.1)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (152, N'EUROSTOXX       ', CAST(0x9C6C0000 AS SmallDateTime), 36.37)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (153, N'EUROSTOXX       ', CAST(0x9C650000 AS SmallDateTime), 37.67)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (154, N'EUROSTOXX       ', CAST(0x9C5E0000 AS SmallDateTime), 37.64)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (155, N'EUROSTOXX       ', CAST(0x9C570000 AS SmallDateTime), 36.36)
 INSERT [dbo].[AssetPrices] ([AssetPricesId], [AssetID], [DatePrice], [OpenPrice]) VALUES (156, N'EUROSTOXX       ', CAST(0x9C500000 AS SmallDateTime), 35.08)
 SET IDENTITY_INSERT [dbo].[AssetPrices] OFF
 /****** Object:  ForeignKey [FK_AssetPrices_Assets]    Script Date: 11/24/2010 13:37:42 ******/
 ALTER TABLE [dbo].[AssetPrices]  WITH NOCHECK ADD  CONSTRAINT [FK_AssetPrices_Assets] FOREIGN KEY([AssetID])
 REFERENCES [dbo].[Assets] ([AssetID])
 GO
 ALTER TABLE [dbo].[AssetPrices] CHECK CONSTRAINT [FK_AssetPrices_Assets]
 GO

Source Code to Index() in Controller

 public ActionResult Index()
 {
     // ASP.NET MVC makes it easy to pass data from a controller to a view, 
     // using the ViewData dictionary or, in the case of strongly-typed views, 
     // passing the model class directly to it
     ViewData["Message"] = "Hello from this On-Premise MVC App";
  
     return View();
 }

As explained in the video, user requests end up as calls to action methods, such as the one above, “Index().” The video then takes you to adding a data layer. The next step involves making a LINQ query in the Index() method to retrieve data and communicate that to the “Model.”

Modifying Index() to make calls to a SQL Server database

Snippet – Query Database

Source Code to Query Database

 using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Web;
 using System.Web.Mvc;
 /////////////////////////////////////////////////////////////////////////////
 //                Add the "using" statement
 /////////////////////////////////////////////////////////////////////////////
 using TierData;  // added this line
  
 namespace MvcOnPremiseToCloud.Controllers
 {
     [HandleError]
     public class HomeController : Controller
     {
         public ActionResult Index()
         {
             /////////////////////////////////////////////////////////////////////////////
             //                Add the next 2 lines of code
             /////////////////////////////////////////////////////////////////////////////
             MarketIndexDataEntities _db = new MarketIndexDataEntities(); // added this line
             // We will execute a LINQ query to get data
             ViewData.Model = (from m in _db.AssetPrices select m).ToList(); // added this line
            
             // ASP.NET MVC makes it easy to pass data from a controller to a view, 
             // using the ViewData dictionary or, in the case of strongly-typed views, 
             // passing the model class directly to it
             ViewData["Message"] = "Hello from this On-Premise MVC App";
  
             return View();
         }
  
         public ActionResult About()
         {
             return View();
         }
     }
 }

Snippet – View Code

Source Code for the View

Snippet – Improved Table View

Source code for a better MVC table

Snippet – Improved View

Source Code for Views / Home / Index.aspx

 <%@ Page Language="C#" MasterPageFile="~/Views/Shared/Site.Master" Inherits="System.Web.Mvc.ViewPage" %>
  
 <asp:Content ID="Content1" ContentPlaceHolderID="TitleContent" runat="server">
     Home Page
 </asp:Content>
  
  
 <asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
     <h2>Market Index Price Listing</h2>
     <table>
       <tr>
         <th> Ticker Symbol </th>
         <th> Date </th>
         <th> Open Price</th>
       </tr>
       <% foreach (TierData.AssetPrice item in (IEnumerable<TierData.AssetPrice>)(ViewData.Model))
          { %>    
       <tr>
         <td> <%= Html.DisplayFor(c => item.AssetID) %> </td>
         <td> <%= Html.DisplayFor(c => item.DatePrice)%> </td>
         <td> <%= Html.DisplayFor(c => item.OpenPrice) %></td>
       </tr>
  
       <% } %>
    </table>
  
 </asp:Content>

Snippet – Using Statements for WebRole.cs

Source Code for WebRole.cs - Using Statements

 using Microsoft.WindowsAzure;
 using Microsoft.WindowsAzure.Diagnostics;
 using Microsoft.WindowsAzure.ServiceRuntime;

Snippet – WebRole.cs

Source Code - WebRole.cs

 public class WebRole : RoleEntryPoint
    {
        public override bool OnStart()
        {
            DiagnosticMonitor.Start("DiagnosticsConnectionString");
  
            // For information on handling configuration changes
            // see the MSDN topic at https://go.microsoft.com/fwlink/?LinkId=166357.
            RoleEnvironment.Changing += RoleEnvironmentChanging;
  
            return base.OnStart();
        }
  
        private void RoleEnvironmentChanging(object sender, RoleEnvironmentChangingEventArgs e)
        {
            // If a configuration setting is changing
            if (e.Changes.Any(change => change is RoleEnvironmentConfigurationSettingChange))
            {
                // Set e.Cancel to true to restart this role instance
                e.Cancel = true;
            }
        }
    }

Migrating MVC Apps to the Cloud

Additional resources