December 2009 Entries

Update to my post on SQL Azure Migration Wizard
Earlier I had written on migrating your Northwind database from SQL Server to SQL Azure. In that, I had mentioned that the SQL Azure Migration Wizard supports migrating the schema and doesn’t do the data migration which has to be done manually. Meanwhile, George Huey has published a recent version on the SQL Azure Migration Wizard at CodePlex which also does data migration. What this means is that, you can take an existing database and generate the scripts and go ahead and deploy the database along ......

Posted On Wednesday, December 23, 2009 2:04 AM | Comments (13)

Moving your ASP.NET Application to Windows Azure – Part II
In the previous post I had described the steps to secure your Windows Azure tokens and get the necessary Visual Studio templates as well as making your web application Azure ready by adding the cloud project and building against it. Once you have tested the Development Fabric, the instances as well as the application, the next step would be to publish it to the Windows Azure platform. Select the “CloudService1” project that you added to the solution, right click and select “Publish” Once you click ......

Posted On Saturday, December 19, 2009 8:47 AM | Comments (312)

Moving your ASP.NET Application to Windows Azure – Part I
Earlier I had written 2 posts – Taking your Northwind Database to SQL Azure and binding it to an ASP.NET GridView Part I and Part II . I thought, I will complete the series with a post on moving your ASP.NET Application as well to Windows Azure making it a truly cloud based application. Before we start, there are a bunch of things that you would need to do. First and foremost, you would need a Token for Windows Azure. You can request for a free token for Windows Azure from here after providing your ......

Posted On Friday, December 18, 2009 1:48 AM | Comments (200)

Binding Entity Framework to your SQL Azure Database – Visual Studio 2010 Beta 2
If you have used the Entity Framework that shipped with Visual Studio 2008 SP1, you would really start appreciating the flexibility it offers for building schema driven data access layer and get it to the UI Layer either directly or using a middle tier such as WCF RIA Service. Check my earlier post on this, if you are interested further :) Meanwhile, the other exciting stuff that has been around is the SQL Azure which is part of the Windows Azure platform. SQL Azure provides relational data over ......

Posted On Thursday, December 17, 2009 7:23 PM | Comments (43)

SQL Azure Connection Error: "Server name cannot be determined. It must appear as the first segment..." - Visual Studio 2010 Beta 2
While working on SQL Azure connectivity from Visual Studio 2010, I faced the above error. The full error text is as below:- “Server name cannot be determined. It must appear as the first segment of the server's dns name (servername.database.window... Some libraries do not send the server name, in which case the server name must be included as part of the user name (username@servername). In addition, if both formats are used, the server names must match. “ As the message suggested, I tried putting ......

Posted On Thursday, December 17, 2009 6:14 AM | Comments (1)

FIX for Unable to find “Microsoft.ServiceHosting.ServiceRuntime” Windows Azure Training Kit Nov 09
Ok, I am playing with the Windows Azure Training Kit November 2009 release and the first sample I wanted to try was “Migrating web applications to Windows Azure”. I believe a whole bunch of people moving to Azure aren’t just going to create new web apps but rather try and move their existing web apps which is why, I thought this exercise is more important. After following the initial few steps, I came to the place where we manage state providers and one of the requirement is to the StorageClient ......

Posted On Tuesday, December 15, 2009 11:51 PM | Comments (27)

Using WCF RIA Services without Silverlight in Visual Studio 2010 for building 3 tier ASP.NET Applications
I have been playing with the WCF RIA Services (erstwhile .NET RIA Services) for sometime and found that most of the samples out there focus on Silverlight based applications. While the new WCF RIA Services preview for VS 2010 is awesome in terms of its Silverlight integration, I also wanted to test out on building plain vanilla ASP.NET Applications and using the power of WCF RIA Services to build a middle tier for the same. Ok, to begin with, I already had Visual Studio 2010 Beta 2 installed and ......

Posted On Monday, December 14, 2009 8:09 AM | Comments (265)