MVC3 asp.net 4.0 Entity Framework 4.02 SQLCE 4 and SEO part 1

I am currently struggling with an idea to create a SEO-friendly site Bankrutt.se with asp.net 4.0 running MVC3 with razor and Entity Framework 4.02.
The database is the new SQLCE 4.0.

The whole solution is hosted externally running asp-net 4.0 x64.
I had a nice SQLite solution earlier but as you might noticed SQLite is still only shipped as X86. Since my web hosting haven’t checked the check box allowing 32 bits assemblies i had to come up with something else.

I cant say that it all fitted together smoothly…

One of the first problems that emerged was the ability to create an EF model with the SQLCE database.
I had to do a lot of upgrades to VS 2010 and it finally worked. I still cant put my EF-model in a library project, it has to be placed in the web site project.

The other problem that quickly bubbled up was using membership provider with SQLCE. Read this article if you are planning to do this.