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.

In the 1.2 Release of the SDK we can now publish straight from VS instead of manually uploading files.

The end results is this:

which automatically publishes up to the cloud and runs the app making it live.

The way to do it is to select manage in Credentials, which brings up this box:

1. Create a self signed cert. 

2. upload it to the dev portal

3 grab your subscriptionid from Account page

You’ll need a storage account to setup through as well.

DevDays – MVC – Scott Hanselman video:

WFT1_2MB_ch9.wmv 1.4GB

Looking at the callstack in debug to see how things are called.

IHttpHandler – the ‘simple’ building block of ASP.NET.

Example in c:\code\mvc2\hanselman

http://localhost:1476/Home/poop/2

Controller get invoked

Action invoker calls the method

Model Binding – took the other piece of the route data (ie 2) and coerced it into…

didn’t call HttpRequest or anything..

Passing a DateTime

Phil Haack Route Debugger

http://haacked.com/archive/2008/03/13/url-routing-debugger.aspx

prop tab tab to auto gen the properties. then tab tab, then enter enter!

Create A Controller

Ctrl M, Ctrl C

Convention is HomeController

var p = new person

then ctrl period to import the namespace.

Create A View

Convention is in Views directory, create a new Person directory.

Index method links to Index view

Details method links to details view.

Ctrl M Ctrl V to create a view, when you are in the appropriate Controller class (eg Index)

Created a strongly typed view.. this Viewpage is of type Person

Model in the viewpage will always be of type T ie Person.

Could use Repository Pattern for the DB

Going live with ASP.NET4 – many hosting providers need you to upgrade to another machine.

Going Live on Azure

Created a new MVC2 Web Role project

Upload to test that MVC2 is working somewhat

ViewModel - MVCMusicStore

VS2010 Control comma – navigate to

http://mvcmusicstore.codeplex.com/

Uses Entity Framework.

Uses <%: HTml.DisplayForModel

AutoMapper

FirstName, LastName.. map to FirstName and Surname

ViewData

is another way to pass data.

ViewEngines

This is the WebForms view engine.

Routing

NerdDinner – MVC2 in beta (now it is live 27th May)

there are unit test in here.

just asserting not null.

Seperation of Concerns – in controller we can’t have Response.Write.. as it would break in this test.  Would work at runtime.

Personal storage

Endpoints:

xxxxx.blob.core.windows.net

xxxx,queue.core.windows.net

xxxx.table.core.windows.net

This part of Windows Azure and not SQLAzure or AppFabric

azurestorageexplorer.codeplex.com

Also looking at Azure Diagnostics Manager from cerebrate.com

http://social.msdn.microsoft.com/Forums/en/windowsazure/thread/e972b0c0-3a04-4f0c-a73f-ab93552d8291

Example using ASP.NET and Storage and AppFabric Local Dev

http://msdn.microsoft.com/en-us/magazine/ee336122.aspx

Logging

Each app has to do its own logging and write to storage.. an app like this can nicely show what is happening.

http://microsoftpdc.com/sessions/svc15 –  this is pdc09

MIX2010 – Building and Deploying Windows Asure Based Apps

http://live.visitmix.com/MIX10/Sessions/SVC09  (Jim Nakashima)

Created a WebRole and a WorkerRole

One of the web roles.. when I clicked on the button, the worker role picked up the message from the queue.

Nerdinner MVC1 Migrating to Azure with SQLAzure

Could use Azure tables (examples on the web)

Need to do 3 things:

- Need to make a webrole

- Migrate dinner to use SQLAzure

- Migrate asp.net membership provider for SQLAzure.

http://blogs.msdn.com/b/brandonwerner/archive/2009/11/28/how-to-host-your-site-and-content-on-azure-quickly-and-easily.aspx

Local Development Fabric and Development Storage (uses SQLEXPRESS)

Live ‘Fabric’ and Storage which consists of Blob, Queue and Table

SQLAzure is something else!

AppFabric is something else.

http://neudesic.cloudapp.net/azureoi.aspx

http://microsoft.com/windowsazure/tco

There is an intro special which you’ll need a credit card to sign up for.

I then clicked Portal Home, and Manage Subscriptions and it seemed to work:

windows.azure.com - dashboard

Need Win7, Server 2008 or Vista..

http://www.microsoft.com/windowsazure/getstarted/

I run a windows7 VMWare image only had a 10gig partition, so off to easyvmx.com

put this is in the vmx file:

# Second SCSI disk image, size 25Gb
scsi0:1.present = "TRUE"
scsi0:1.fileName = "My_Virtual_Machine-2.vmdk"
scsi0:1.mode = "persistent"
scsi0:1.startConnected = "TRUE"
scsi0:1.writeThrough = "TRUE"

and the empty vmdk in the directory too.

Uninstalling the express version, then putting on a trail full version (many hours!  time for coffee and to chill out)

Forums

http://social.msdn.microsoft.com/Forums/en-US/windowsazure/threads

Putting SQL Server Express 2008 on my Win7 VM.

nice.. this may have just been the studio, without SQL

Ok.. so trying the SQ:EXPR_x86_ENU.exe – hopefully the SP1 which is compatible with Win7.. need Mgt Studio too.

Probably Best to use the Web Platform Installer

Download Azure Tools for Visual Studio 1.1 (Feb 2010)

Need IIS7 and dev tools running.

Examples

AzureBright CMS – no source code as yet. MVC2

http://code.msdn.microsoft.com/mytodo – MVC1 futures.

http://code.msdn.microsoft.com/windowsazuresamples – Hello world.

Windows Azure Platform Training Kit

need dev accounts for:  Azure, SQL Azure and Azure plaform AppFabric

http://code.msdn.microsoft.com/windowsazuresamples

Going through Demos tab in the Windows Azure Training Kit – didn’t work

Creating a Storage Account:

djhmateer,blob.core.windows.net – Storage account

djhmateer.cloudapp.net

MyTodo.cspkg – this is the app package

ServiceConfiguration.cscfg – conf file

When I got to Configuring – unclear exactly what to do:

after thinking I’d made a mistake in my configuration file having angle brackets in there []

I tried without.  Seems to have hung on updating deployment.  Tried to delete the service.  Couldn’t.  hmmm.

**where are the error logs?

Hello World Example – this worked

http://weblogs.asp.net/jeffwids/archive/2010/03/02/getting-started-with-windows-azure-part-0-where-do-i-go-to-get-started.aspx

the crowd goes wild..

And after probably 15minutes, the light went to Ready, and we went live.

I’ve downloaded the Azure Tools.. do I need the SDK?

ASP.NET MVC2 – This Worked

Did an Upgrade of HelloWorld.  And got a role not found

Trying a delete and a new deploy.

There is no SQL Server or data storage wired up yet