Previous Posts that you should review

bullet

Step 1
hyperlink[6]

http://blogs.msdn.com/b/brunoterkaly/archive/2010/06/12/creating-an-on-premise-database-and-mvc-web-application-and-migrating-to-windows-azure-and-sql-azure-step-1-of-10.aspx

bullet

Step 2
hyperlink[6]

http://blogs.msdn.com/b/brunoterkaly/archive/2010/06/11/creating-an-on-premise-database-and-mvc-web-application-and-migrating-to-windows-azure-and-sql-azure.aspx

bullet

Step 3
hyperlink[6]

http://blogs.msdn.com/b/brunoterkaly/archive/2010/06/27/creating-an-on-premise-database-and-mvc-web-application-and-migrating-to-windows-azure-and-sql-azure-step-3-of-10.aspx

bullet

Step 4
hyperlink3

http://blogs.msdn.com/b/brunoterkaly/archive/2010/06/28/creating-an-on-premise-database-and-mvc-web-application-and-migrating-to-windows-azure-and-sql-azure-step-4-of-10.aspx

bullet

Step 5
hyperlink

http://blogs.msdn.com/b/brunoterkaly/archive/2010/06/28/creating-an-on-premise-database-and-mvc-web-application-and-migrating-to-windows-azure-and-sql-azure-step-5-of-10.aspx

 

Introduction

Pointing to the cloud
We want our MVC application to get the data from the cloud (SQL Azure). To retrieve data from SQL Azure, it is incredibly easy:

bullet_thumb1

A simple change in the MVC’s connection string will make the change

This is a relevant use case

High availability and fault tolerance is built-in and no physical administration is required for SQL Azure. This is potentially an architecture that will work for many businesses – to have the data hosted in the cloud but have the web applications (Web Forms or MVC) hosted on premise.

 

The Connection String – Found in app.config

Currently configured for “On Premise”
Notice that the connection string is found in App.config. Also notice that we are pointing to a Data Source=(local).
snap0134

The New Connection String 

Points to SQL Azure
Our data source is now
    <add name="ModelStocksContainer" connectionString="metadata=res://*/ModelStocks.csdl|
         res://*/ModelStocks.ssdl|res://*/ModelStocks.msl;provider=System.Data.SqlClient;
         provider connection string=
         &quot;Data Source=tcp:bjzkzsxp9c.database.windows.net;Database=stocksdb;
         User ID=brunoterkaly@bjzkzsxp9c;Password=[your password goes here];Trusted_Connection=False;
         Encrypt=False&quot;" providerName="System.Data.EntityClient"
         />
snap0135

Connection String is in both projects 

We need to adjust the connection string in 2 places
As you recall from a previous post, the connection string is in both projects:

bullet

DataLayer

bullet

MvcOnPremise
snap0136snap0137snap0138snap0139

On Premise Web App – Cloud hosted database

Hybrid Application
At this point you may decide you are done. That is, your application will be hosted ‘on-premise’ but the  but he data is hosted in the cloud in SQL Azure.
snap0142

 

Future Posts for this blog

Move MVC Web App to Windows Azure
We will conclude this series of posts by migrating our web application to the cloud. At this point, the data is in the cloud, but not the application.