Folks, I've been running experiments for days now to get the hang of deploying and running WCF services and SQL databases in Azure. I have the database up and running fine.
The service has a simple "sanity check" method that just returns a random number, and some other methods that return EF5 entities out of the Azure SQL database. All methods work perfectly in the Azure simulator, but when I deploy to Azure staging or production the simple method works but the database methods fail with a generic fault message with no diagnostic information. What tricks or techniques are available to debug what's happening on the Azure service side? Is anyone here using Azure for serious stuff? If so, your general advice would be welcome to help me get up-to-speed and save suffering. Thanks Greg P.S. I'm quite impressed with Azure generally and the nice management interface, but it sure is slow to deploy, and sometimes the first call to the service fails with "no endpoint" but a minute later it works, like it's "waking up" or something.
