title: Azure SQL database working when ran locally but not when published to Azure
body: <p>This has been cracking me up for a few days now and I just can't solve it.</p>
  
  <p>I followed an online tutorial showing you how to connect and use an Azure database using the model first approach within Entity Framework. With this you had to set up database migrations as to update the Azure database when publishing the website to Azure.</p>
  
  <p>I had already created a database on Azure so I thought I would take the approach of using a database first model (also it didn't require migrations to be setup) and used the Entity Framework wizard to create my model. Everything worked perfectly and when I run my MVC website locally it connects to my Azure database and shows the data, etc. However, when I publish the website to the Azure website, for some reason, when I click on tab that uses the controller that gets data from the database, I get an error: </p>
  
  <blockquote>
    <p>Sorry, an error occurred while processing your request.</p>
  </blockquote>
  
  <p>I have checked my connection strings and they all seem OK and as I said, when I run it locally I can get the data from the Azure database. For some reason, though, I can't get the data once its published.</p>
  
  <p>Any ideas?</p>