Thanks for your answer. I have to say I'm a little disappointed though. Version 4.0 was already Azure SQL ready in terms of DB at launch as I showed nearly 9 months ago in this forum post
. There were some connection issues that I pointed out in the same post, but I was told this was an ORM problem and would be fixed. I haven't tested whether this has been fixed in 4.1, maybe someone else has?
As far as I'm concerned this hasn't gone forward at all though. The main difference is that now Azure allows you to RDP to a Role and so can change the permissions on the App_Data folder, allowing it to function on a single role. However nobody in their right mind would use this for anything production, even for a test it will get pretty dull if you can lose your Apps config at any moment you have no control over. There is no point using it.
Yes a provider to use Azure Blob Storage would be great, a DB storage provider is much more urgent I would say though.
There is maybe a work around as long as you are happy with a single Role solution. If you use an Azure Drive and then change the location of the config folder in Sitefinity this might work. The Blob store behind the Azure Drive is persistent so would survive the Role being restarted. I haven't tried this, if Telerik want to give me access to an account I'm willing to get a test working as I did before.
I'm not sure what to do now, I may have to look for other more Azure ready software. I don't think others like Kentico are that far ahead though, last time I looked their version was restricted to single Web Roles and used Azure Drives as well.
I'm disappointed, this was a real chance for Sitefinity to take the lead and it has been missed, a real shame. Maybe it will come, I know there have been lots of other more fundamental problems with version 4 that needed sorting first, but for those of use waiting and hoping for features like this it's getting very frustrating.