Azure Sql Database Working When Ran Locally But Not When Published To Azure

This has been cracking me up for a few days now and I just can't solve it. I followed an online tutorial showing you how to connect and use an Azure database using the model first

Solution 1:

Thankyou everyone for your help.

I didn't even think of turning on the copy local however when I checked it it was set to true. So no answer there :(

Next I added the customerrors mode to off to try and get a more detailed description. The error I got was huge and really didn't make much sense so i did the usual thing and googled the error and I found this

Can anyone spot why I keep getting this error testing the EF 5 beta

As soon as I read it i knew this would fix it. I originally setup the project as a .net 4.5 project until I realized that azure websites didn't work with 4.5 yet so I changed it to .net 4 once I uninstalled EF and reinstalled it everything work.

Thanks for all your help. This has been stopping me doing anything for a few days :P