SQL CE Deploy - AppHarbor - Unable to load the native components of SQL Server Compact

Question

I have followed the following posts completely:

http://support.appharbor.com/discussions/problems/544-error-with-reference-to-systemdatasqlserverceentity-dll

Using SQL Server CE 4 on a remote host with MVC 3

and I am still receiving the following error:

Unable to load the native components of SQL Server Compact corresponding to the ADO.NET provider of version 8482. Install the correct version of SQL Server Compact. Refer to KB article 974247 for more details.

What I have done:

Fresh File -> New ASP.NET MVC 3 application. Via NuGet added EFCodeFirst.SqLServerCompact v0.8.8482.1 which added the necessary packages.

Locally everything works great. I build/clean/rebuild and commit the entire solution via Git and push to AppHarbor. All pages not touching SQL CE work as expected. When I try and load the page that is talking to SQL CE I see the attached exception:

Below are my packages installed:

Below is what my Bin directory looks like:

Answer 1

I couldn't get this working either, I spent ages on trying. I ended up just changing over to the proper SQL Server supported by AppHarbor (since using SqlCompact in the App_Data folder is dangerous for various reasons anyway).

Answer 2

SQL server CE can be made to run on AppHarbor, although we don't recommend using it for the reasons Danny Tuppeny mention. This support case contains working code.