title: Changing from local database to SQL Server hosted on a server
body: <p>So I'm fairly new to MVC and C# in Visual Studio. I recently completed the tutorial located at:</p>
  
  <p><a href="http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-application" rel="nofollow">http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-application</a></p>
  
  <p>It was fun and educational in some aspects. I have one question though about the database it connects to, in the tutorial it creates a local SQL Server database and the CRUD then works off that. I currently have an external SQL Server database hosted on a server that I would like to be able to play with, I have successfully connected to it through Visual Studio (2012) but was wondering how hard it is to transfer the CRUD over to it. </p>
  
  <p>After reading up a little bit I altered the connection string, and added:</p>
  
  <pre><code>using System.Data.SqlClient
  </code></pre>
  
  <p>But I am still using:</p>
  
  <pre><code>using System.Data.Entity
  </code></pre>
  
  <p>Unsure if I need both, and I am ofc using EF (Entity Framework).</p>
  
  <p>Can anyone advise what other steps would need to be done in order to successfully transfer this over? Or in what direction I should look because tbh I am not a database or SQL expert (or MVC) and it gets a bit confusing. </p>
  
  <p>Any helps, links or tutorial locations would be greatly appreciated.</p>