title: Azure error when using EF agains SQL Server CE 4.0 database
body: <p>I have an ASP.NET MVC 3 application which I want to deploy to Azure.  The application uses EF against a SQL Server CE 4.0 database in the App_Data directory.  </p>
  
  <p>The site runs fine locally but when I reference it from an ASP.NET MVC 3 web role and publish it to Azure I get this error:</p>
  
  <p><strong>"Unable to find the requested .Net Framework Data Provider.  It may not be installed."</strong>
  The full exception can be viewed here: <a href="http://52df5a4a5c1b4d10a927078bb8a06d15.cloudapp.net/drug" rel="nofollow">http://52df5a4a5c1b4d10a927078bb8a06d15.cloudapp.net/drug</a></p>
  
  <p>Here is connection string from the web.config file:</p>
  
  <pre><code>&lt;add name="DbEntities" connectionString="metadata=res://*/AMDBModeledmx.csdl|res://*/AMDBModeledmx.ssdl|res://*/AMDBModeledmx.msl;provider=System.Data.SqlServerCe.4.0;provider connection string=&amp;quot;Data Source=|DataDirectory|\AMDB.sdf&amp;quot;" providerName="System.Data.EntityClient" /&gt;
  </code></pre>
  
  <p>I have tried compiling my project to target x86 and setting the "Copy Local" property of the System.Data.Entity reference to true.  Nothing helps. </p>
  
  <p>Is it possible to run a web app in Azure and use a file-based database?  I understand this can be a problem with multiple instances, but I'm only using a single VM.</p>