Microsoft SQLServer Compact 4.0 with SP1

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. SQL Server Compact 4.0 has a small footprint and supports private

deployment of its binaries within the application folder, easy application development in Visual Studio and

WebMatrix, and seamless migration of schema and data to SQL Server.

## Features

* Default database for Microsoft WebMatrix, which is a stack of web technologies for easily building and deploying

websites on the Windows platform

* Visual Studio can be used to develop ASP.NET web applications and websites using SQL Server Compact 4.0

* Enabled to work in the medium or partial trust environments in the web servers, and can be easily deployed along with

the website to the third party website hosting service providers

* Private deployment of SQL Server Compact further simplified by having all the required managed assemblies, and the

x86 and x64 DLLs, including the Visual C++ 2008 runtime libraries (x86 and x64) SP1 in a single private folder in the

install location of SQL Server Compact

* Stronger data security with the use of the SHA2 encryption algorithms for encrypting the databases

* T-SQL syntax enhancement by adding support for OFFSET and FETCH that can be used to write paging queries and new APIs

* like SqlCeConnection.GetSchema that provides the metadata information of the database

* Used with ADO.NET Entity Framework, SQL Server Compact now supports the columns that have server generated keys like

identity, rowguid etc. and the code-first programming model

## Package Parameters

The `language` package parameter can be set to install the package with the specified language. If no language is