Using SQL Server Compact Edition in ASP.NET websites?

From the download site for SQL Server Compact 4.0.

From the download site for SQL Server Compact 4.0: Microsoft SQL Server Compact 4.0 is a free, embedded database that software developers can use for building ASP. NET websites and Windows desktop applications. And: SQL Server Compact 4.0 enables new scenarios and includes a host of new features, including the following: SQL Server Compact 4.0 is the default database for Microsoft WebMatrix, which is a stack of web technologies for easily building and deploying websites on the Windows platform.(emphasis mine) In conclusion - it has specifically been enhanced for web scenarios.

Yes, SQL Server Compact 4.0 has been designed with scenarios similiar to yours in mind. New Embedded Database Support with ASP. NET SQL CE is a free, embedded, database engine that enables easy database storage.No Database Installation Required SQL CE does not require you to run a setup or install a database server in order to use it.

You can simply copy the SQL CE binaries into the \bin directory of your ASP. NET application, and then your web application can use it as a database engine.No setup or extra security permissions are required for it to run. You do not need to have an administrator account on the machine.

Just copy your web application onto any server and it will work. This is true even of medium-trust applications running in a web hosting environment. SQL CE runs in-memory within your ASP.

NET application and will start-up when you first access a SQL CE database, and will automatically shutdown when your application is unloaded. SQL CE databases are stored as files that live within the \App_Data folder of your ASP. NET Applications.

Visual Studio 2010 SP1 includes new tooling support for SQL CE.

Great tool, but... what kills it for me is that it doesn't support stored procedures. – IrishChieftain Sep 23 at 15:11.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.