CODEWITHSUNDEEP
asp.net-mvc-3hostingsql-server-cehost
ridermansb
ridermansb

Reputation: 11069

Hosting site Asp.net MVC and SQL Server Compact 4

In my ISP, they must hire service SQL Server to host a sql server compact framework? The fact that MVC requires the host to have some extra service? Or a simple hosting plan already supports asp.net MVC?

Upvotes: 1

Views: 1987

Answers (1)

Darin Dimitrov
Darin Dimitrov

Reputation: 1039438

You can bin-deploy SQL CE 4. Just make sure you are using the RTM version because there was a problem with bin-deployment in betas. Also see Scott Gu's blog post about it.

ASP.NET MVC 3 can also be bin-deployed if your hosting provider doesn't have the assemblies installed in the GAC. All that's need is .NET 4.0.

This being said SQL CE is an embedded database and not designed to work in a heavy multithreaded environments such as ASP.NET. It is good for development and light-usage scenarios. For high-volume sites and applications you'll probably want to migrate it to use SQL Server Express or SQL Server.

Upvotes: 2

Related Questions