Creating an On Premise Database and MVC Web Application and Migrating to Windows Azure and SQL Azure-Step 6 of 10

Previous Posts that you should review Step 1 https://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 Step 2 https://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 Step 3 https://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 Step 4 https://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 Step 5 https://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: 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) .

The New Connection String  Points to SQL AzureOur 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" />

Connection String is in both projects  We need to adjust the connection string in 2 placesAs you recall from a previous post, the connection string is in both projects: DataLayer MvcOnPremise

On Premise Web App – Cloud hosted database Hybrid ApplicationAt 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.

 

Future Posts for this blog

Move MVC Web App to Windows AzureWe 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.