title: Entity Framework works on Local Server but not Remote
body: <p>Ok so I have a website that uses ASP.net mvc, the problem I am having is with Entity Framework.  I added all the references and got it to run on my local machine but when I publish it I get the following error.</p>
  
  <p>System.InvalidOperationException: The Entity Framework provider type 'System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' for the 'System.Data.SqlClient' ADO.NET provider could not be loaded. Make sure the provider assembly is available to the running application. See <a href="http://go.microsoft.com/fwlink/?LinkId=260882" rel="noreferrer">http://go.microsoft.com/fwlink/?LinkId=260882</a> for more information.</p>
  
  <p>I have double checked my references and I have EntityFramework.SqlServer and System.Data both added into my project.  The connection string I use to connect to the data base and declare the service provide is below.</p>
  
  <pre><code>&lt;connectionStrings&gt;
  &lt;add name="[dataConnection]" connectionString="Data Source=[ip of host machine];Database=[name];UID=[user];pwd=*******;MultipleActiveResultSets=True;" providerName="System.Data.SqlClient" /&gt;
    &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>Name we just have the name of the data base, this is also used in my web.debug.config</p>
  
  <pre><code>&lt;connectionStrings&gt;
  &lt;add name="[dataconnection]"
    connectionString="Data Source=.;Database=[name];UID=[user];pwd=*******;MultipleActiveResultSets=True;"
    xdt:Transform="SetAttributes" xdt:Locator="Match(name)"/&gt;
    &lt;/connectionStrings&gt;
  </code></pre>
  
  <p>I am pretty new to this entire thing and was just handed someone elses code so I am trying to learn on the flow.  This is my first encounter with this so any direction would be appreciated.</p>