I’m working on a simple splash screen which collects the user’s email address and saves it in a database. I decided to use a SQL Server Compact Edition database and include it in my MVC4 website’s App_Data folder.
This worked great in my development environment, however, after deploying the site to Azure I would get the following error:
Unable to find the requested .Net Framework Data Provider. It may not be installed.
I figured that Azure didn’t have the necessary dependency available – and I had it locally because I was running Visual Studio which had most likely already installed the necessary dependency.
Instead of messing manually with bin-deployable assemblies, I went straight to NuGet.
I installed the EntityFramework.SqlServerCompact package which also installed the Microsoft SQL Server Compact Edition package that it depended on.
I then deployed to my site and everything worked like a charm.
Hope this helps.