title: Database for testing and public database. How to use both?
body: <p>Currently I have my project connected to the database placed on Windows Azure, but I will be soon publishing my website for other people. When I'm making changes to my site, I often make changes to the database too. So during my work on my site, public webpage will not work.</p>
  
  <p>How can I create local database which will be used locally, while testing and how can I automatically switch to this public db when my project is in Internet? </p>
  
  <p>I use Asp.Net MVC5 with Entity Framework.</p>