Generate Database project from Azure database

Azure Database

In this topic I will show you how to generate own database project from SQL Azure Database. We used SQL Management Studio 2012 to create and generate a database. Also, I will use our solution MvcApplicationWebRole that I have created and used in the previous post.

First you need to have created SQL Server in Azure. You can do it in Manage Windows Azure site

New SQL server 

To create new SQL server go by the link above and press button “+ New” in the bottom of the page. Then use the wizard and select action “Data Services – SQL database – Custom create”:

Wizard to create new Database on existing or new SQL Server

Wizard to create new Database on existing or new SQL Server

  More...

Add Windows Azure Web Role to your MVC project

The June 7th update to Windows Azure introduced two new services (Windows Azure Websites and persistent VMs), or Web Role and Worker Role:

Azure Web Role and Worker Role

Image 1 – Web Role and Worker Role

 

In this article I will show you how to add new Web Role to your project. As a project we will use simple MVC 4 application. I am using Visual Studio 2012. In second image we can see a tree of our new MVC 4 application:

 More...