Windows_Azure_SQL_Database_Tutorials.pdf

Windows Azure and

SQL Database Tutorials

Jonathan Gao

Summary: These Windows Azure and SQL Database (formerly SQL Azure) tutorials are

designed for beginners who have some .NET development experience. Using a common

scenario, each tutorial introduces one or two Windows Azure features or components.

Even though each tutorial builds upon the previous ones, the tutorials are self-contained

and can be used without completing the previous tutorials.

Category: Step-by-Step

Applies to: Windows Azure SQL Database

Source: TechNet Wiki ( link to source content )

E-book publication date: November 2012

without the written permission of the publisher.

Microsoft and the trademarks listed at

http://www.microsoft.com/about/legal/en/us/IntellectualProperty/Trademarks/EN-US.aspx are trademarks of the

Microsoft group of companies. All other marks are property of their respective owners.

The example companies, organizations, products, domain names, email addresses, logos, people, places, and events

depicted herein are fictitious. No association with any real company, organization, product, domain name, email address,

logo, person, place, or event is intended or should be inferred.

This book expresses the author’s views and opinions. The information contained in this book is provided without any

express, statutory, or implied warranties. Neither the authors, Microsoft Corporation, nor its resellers, or distributors

will be held liable for any damages caused or alleged to be caused either directly or indirectly by this book.

Contents

Before You Begin the Tutorials ................................................................................................................ 5

Set Up the Development Environment................................................................................................. 5

Installing the Tutorial Files ................................................................................................................... 5

Installing the Code Snippets................................................................................................................. 5

Using the Code Snippets ...................................................................................................................... 6

Provisioning Windows Azure................................................................................................................ 6

Tutorial 1: Using Windows Azure Web Role and Windows Azure Table Service ........................................ 7

Overview ............................................................................................................................................. 7

Lesson 1: Create a Windows Azure Visual Studio Project.................................................................... 11

Lesson 2: Create a Data Source .......................................................................................................... 13

Lesson 3: Create a Web Role to Display the Message Board and Process User Input .......................... 19

Lesson 4: Test the Application and Deploy the Application................................................................. 24

Tutorial 2: Using SQL Database .............................................................................................................. 29

Overview ........................................................................................................................................... 29

Lesson 1: Prepare SQL Database Account........................................................................................... 33

Lesson 2: Modify the Application to use SQL Database ...................................................................... 37

Lesson 3: Test and Deploy the Application ......................................................................................... 42

Tutorial 2.1: Create an OData Service .................................................................................................... 46

Overview ........................................................................................................................................... 46

Lesson 1: Modify the Application to Define the Entity Framework Data Model .................................. 47

Lesson 2: Modify the Application to Add the Data Service.................................................................. 50

Lesson 3: Test and Deploy the Application ......................................................................................... 52

Tutorial 3: Using Windows Azure Blob Service ....................................................................................... 57

Overview ........................................................................................................................................... 57

Lesson 1: Modify the Application to Use the Blob Service .................................................................. 61

Lesson 2: Test and Deploy the Application ......................................................................................... 67

Tutorial 4: Using Windows Azure Worker Role and Windows Azure Queue ........................................... 72

Overview ........................................................................................................................................... 72

Lesson 1: Modify the Message Data Model ........................................................................................ 76

Lesson 2: Modify the Web Role.......................................................................................................... 81

Lesson 3: Add a Worker Role for Background Processing ................................................................... 83

Lesson 4: Test and Deploy the Application ......................................................................................... 86

These Windows Azure and SQL Database (formerly SQL Azure) tutorials are designed for beginners who

have some .NET development experience. Using a common scenario, each tutorial introduces one or

two Windows Azure features or components. Even though each tutorial builds upon the previous ones,

the tutorials are self-contained and can be used without completing the previous tutorials.

Windows Azure is an open cloud platform that enables you to quickly build, deploy and manage

applications across a global network of Microsoft-managed datacenters. You can build applications using

any language, tool or framework.

Windows Azure provides three options for executing applications. These options can be used separately

or combined.

•

Virtual Machine: Virtual Machines (VM) provides the ability to create a virtual machine on

demand. You can use the virtual machine as a development computer, or as a server to run your

applications. Once you have a virtual machine created, you can deploy your existing applications

to it without engaging developers to make code changes. The downside of using virtual

machines is that you are responsible to administering the VMs.

•

Web Site: The Web Site option offers a managed web environment using Internet Information

Services (IIS). You can move an existing IIS website into Windows Azure Web Sites unchanged, or

you can create a new one directly in the cloud. Once a website is running, you can add or

remove instances dynamically, relying on Web Sites to load balance requests across them.

•

Cloud Service: Cloud Service i s designed expressly to support scalable, reliable, and low-admin

applications, and it's an example of what's commonly called Platform as a Service (PaaS). To use

it, you create an application using the technology you choose, such as C#, Java, PHP, Python,

Node.js, or something else. Your code then executes in virtual machines (referred to as

instances) running a version of Windows Server.

This set of tutorials demonstrates how to create cloud services:

•

Tutorial 1: Using Windows Azure Web Role and Windows Azure Table Service T his first tutorial

goes beyond a "Hello World" sample to show you how to use a Web role and table service.

•

Tutorial 2: Using SQL Database B ased on the tutorial 1 application, this tutorial replaces the

table service with SQL Database.

•

Tutorial 2.1: Create an OData Service T his tutorial extends tutorial 2 to add an OData service to

access and change data in the SQL Database created in tutorial 2.

•

Tutorial 3: Using Windows Azure Blob Service I n this tutorial, blog storage is added to the

tutorial 1 application for storing binary images.

•

Tutorial 4: Using Windows Azure Worker Role and Windows Azure Queue Service T his tutorial

adds a worker role for background processing, and a queue is used to facilitate communication

between the two roles.

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: