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
The June 7th update to Windows Azure introduced two new services (Windows Azure Websites and persistent VMs), or 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: