Can’t get sql server compact 3.5 / 4 to work with ASP .NET MVC 2
I’m using Visual Studio 2008 Pro.
sql-server-ce
Cannot find namespace ‘System.Data.SqlServerCe’
I did include the System.Data.SqlServerCe dll, put using System.Data.SqlServerCe; in my code, but when I open the .NET page I get:
ASP.NET MVC3 Code-First Error- attempting to update entity
I’ve checked this question and it seems to be related to what I need, but does not answer it exactly.
Deploying SQL CE 4 to IIS 7 – Special Permissions Needed?
I have an ASP.NET 4 site that uses the new SQL CE 4 CTP. The site works fine locally (IIS 7.5 on Win7) and fine in Server 2003/IIS 6. It fails when deploying to IIS 7 on Server 2008. The error I get is: