title: ASP.NET MVC 4 + Entity Framework 6 + SQL Compact Edition 4.0 deployment no install
body: <p>Im trying to deploy a basic MVC 4 app that uses Entity Framework 6 (Code First) and SQL Compact 4.0
  on a clean install of windows 7 with iis installed (mvc 4 and sql compact 4.0 is not installed).</p>
  
  <p>I got the following nuget packages installed on the db project:</p>
  
  <ul>
  <li>EntityFramework (Version 6.0.0-alpha2)</li>
  <li>EntityFramework.SqlServerCompact (Version 6.0.0-alpha2)</li>
  <li>Microsoft.AspNet.Providers (Version 1.2)</li>
  <li>Microsoft.AspNet.Providers.Core (Version 1.2)</li>
  <li>Microsoft.SqlServer.Compact (Version 4.0.8876.1)</li>
  </ul>
  
  <p>In web.config i got the following config:</p>
  
  <pre><code>&lt;connectionStrings&gt;
    &lt;add name="[Name]" connectionString="Data Source=|DataDirectory|[FileName].sdf" providerName="System.Data.SqlServerCe.4.0" /&gt;
  &lt;/connectionStrings&gt;  
  
  ......................
  
  &lt;entityFramework&gt;
    &lt;defaultConnectionFactory type="System.Data.Entity.Infrastructure.SqlConnectionFactory, EntityFramework"&gt;
       &lt;parameters&gt;
          &lt;parameter value="System.Data.SqlServerCe.4.0" /&gt;
       &lt;/parameters&gt;
    &lt;/defaultConnectionFactory&gt;
    &lt;providers&gt;
        &lt;provider invariantName="System.Data.SqlServerCe.4.0" type="System.Data.Entity.SqlServerCompact.SqlCeProviderServices, EntityFramework.SqlServerCompact, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /&gt;
    &lt;/providers&gt;
  &lt;/entityFramework&gt;
  </code></pre>
  
  <p>Bin folder (sql ce files are in amd64 and x86 folder:</p>
  
  <ul>
  <li>[amd64]</li>
  <li>[x86]</li>
  <li>Antlr3.Runtime.dll</li>
  <li>DotNetOpenAuth.AspNet.dll</li>
  <li>DotNetOpenAuth.Core.dll</li>
  <li>DotNetOpenAuth.OAuth.Consumer.dll</li>
  <li>DotNetOpenAuth.OAuth.dll</li>
  <li>DotNetOpenAuth.OpenId.dll</li>
  <li>DotNetOpenAuth.OpenId.RelyingParty.dll</li>
  <li>EntityFramework.dll</li>
  <li>EntityFramework.SqlServer.dll</li>
  <li>EntityFramework.SqlServer.xml</li>
  <li>EntityFramework.SqlServerCompact.dll</li>
  <li>EntityFramework.SqlServerCompact.xml</li>
  <li>EntityFramework.xml</li>
  <li>Microsoft.Web.Infrastructure.dll</li>
  <li>Microsoft.Web.WebPages.OAuth.dll</li>
  <li>Newtonsoft.Json.dll</li>
  <li>ShipMedProto.DB.dll</li>
  <li>ShipMedProto.DB.pdb</li>
  <li>ShipMedProto.Web.dll</li>
  <li>ShipMedProto.Web.pdb</li>
  <li>System.ComponentModel.DataAnnotations.dll</li>
  <li>System.Data.DataSetExtensions.dll</li>
  <li>System.Data.SqlServerCe.dll</li>
  <li>System.Data.SqlServerCe.Entity.dll</li>
  <li>System.Net.Http.Formatting.dll</li>
  <li>System.Web.Helpers.dll</li>
  <li>System.Web.Http.dll</li>
  <li>System.Web.Http.WebHost.dll</li>
  <li>System.Web.Mvc.dll</li>
  <li>System.Web.Optimization.dll</li>
  <li>System.Web.Providers.dll</li>
  <li>System.Web.Razor.dll</li>
  <li>System.Web.WebPages.Deployment.dll</li>
  <li>System.Web.WebPages.dll</li>
  <li>System.Web.WebPages.Razor.dll</li>
  <li>WebActivatorEx.dll</li>
  <li>WebGrease.dll</li>
  <li>WebMatrix.Data.dll</li>
  <li>WebMatrix.WebData.dll</li>
  </ul>
  
  <p>When I deploy to the clean machine I get the following error message:</p>
  
  <p>Unable to find the requested .Net Framework Data Provider. It may not be installed.</p>
  
  <p>On my dev machine it is working fine. (I got sql ce installed)</p>
  
  <p>Any clue what Im doing wrong?</p>