Enabling Entity Framework SQL Server Compact Edition support on Azure Websites

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.

NugetSQLCompact

I then deployed to my site and everything worked like a charm.

Hope this helps.

 

2 comments

  1. Zakos says:

    Thanks , After this I had to manually create App_Folder on Azure using FTP because it didn’t create it

  2. Long Le says:

    Thanks this helped!

Leave a Reply

Your email address will not be published. Required fields are marked *