see about half way down this article for the first working MVC1 app connecting to the db.
http://wag.codeplex.com/
Using the EntLib5
Music Store App (Mar 23rd)
Hello World sample bits of code from MS:
Transferring data up to SQL Azure.. using Script Manager in SQL Man Studio 2008..
http://www.msteched.com/2010/NorthAmerica/COS311
Doing a Simple MVC Application and Publishing up to the Cloud (no DB)
This is a simple new project, Cloud Service, ASP.NET MVC2 Web Role
Right click on the VoucherMVC project, then publish. Upload via the Web Interface.
NerdDinner
http://www.marcmywords.org/post/NerdDinner-hosted-on-Windows-Azure-and-SQL-Azure.aspx
Failed to generate a user instance due to a failure in starting the process… DB Error: Solved by deleting a directory on my local machine (Win 7).
http://www.aspdotnetfaq.com/Faq/fix-error-Failed-to-generate-a-user-instance-of-SQL-Server-due-to-a-failure-in-starting-the-process-for-the-user-instance.aspx
Populating the Database
http://azurefeeds.com/post/923/Migrating_an_Existing_ASP.NET_App_to_run_on_Windows_Azure.aspx
Showing how to export a SQL script into SQL Azure format:
Ok, have got nerddinner database up there.
ASP.NET Membership Provider..
http://blogs.msdn.com/b/jnak/archive/2009/11/24/asp-net-provider-scripts-for-sql-azure.aspx
http://www.marcmywords.org/post/NerdDinner-hosted-on-Windows-Azure-and-SQL-Azure.aspx
Details how to get the asp.net membership provider scripts working, using modified scripts.
http://support.microsoft.com/kb/2006191/en-gb
Issue with NerdDinner MVC2
Came across realm issue with regard to OpenID code, so reverted back to MVC1 code.
NerdDinner MVC1 Migrate to Azure – This Worked
Get it working normally in MVC (with 2 databases running SQLExpress in AppData folder)
Getting the Phone# does not match country error in nerddinner.
hacked the Helper/PhoneValidator.cs to always return true.
Deleted the unit test project for simplicity
Added a CloudService project into the solution
Right clicked on Role in CloudService, and added in the existing NerdDinner project
Added back in ConnectionStrings.config into the NerdDinner project
Coppied the database to SQL Azure using Management Studio 2008R2
Coppied Membership Provider to SQL Azure using special sql scripts
Added in ConnectionStrings.config into the project, and put in SQL Azure string.
Uploaded to Azure..
**problem goes between stopping and initializing… after 20mins?
Try recreating Service in Asia, and DB is in Asia too.
Try uploading again.. and putting one in staging too ( a simple MVC no database, includes test project, worked before). 9:50pm started.
App does work from local using SQL Azure as storage..
After sleeping on it, the problem was that copy local wasn’t set to true on the System.Web.Mvc reference.
