title: Windows 2012 SERVER - No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlClient'
body: <p>I have a WebAPI 2 using EF6 on my local machine and it works perfectly.
  When I PUBLISH the solution and upload it to the server, I get the following error:</p>
  
  <blockquote>
    <p>System.Data.Entity.Core.MetadataException: Schema specified is not valid. Errors: 
    Database.FooModel.ssdl(2,2) : error 0152: No Entity Framework provider found for the ADO.NET provider with invariant name 'System.Data.SqlClient'. Make sure the provider is registered in the 'entityFramework' section of the application config file.</p>
  </blockquote>
  
  <p><strong>Note:</strong><br>
  I see many posts about fixing the development machine but my problem is not that. My problem lies when I upload the code to the Windows 2012 server.</p>
  
  <p><strong>Question:</strong><br>
  How do you ensure that the <strong>SERVER</strong> gets the proper settings when uploading a EF6 solution?<br>
  I already updated the server to DotNet 4.5.1, what else should I install on the server?</p>