SQL Server Compact Books Online Home Page

Microsoft SQL Server Compact 4.0 has a group of new features, including a new scenario where SQL Server Compact 4.0 can be used as a database for ASP.NET Web applications and Web sites. SQL Server Compact 4.0 provides an easy and simple to use database storage for starter Web sites and is a free, easy-to-use, lightweight, and embeddable version of SQL Server 2008 R2. 

With SQL Server Compact 4.0, you can develop both desktop and Web applications in Visual Studio. SQL Server Compact 4.0 is also integrated with the Microsoft Webmatrix, which is a stack of Web technologies for easily developing and deploying Web sites on the Windows platform.

For more information, see What's New in SQL Server Compact 4.0.

For a list of Windows platforms supported by SQL Server Compact 4.0, see Hardware and Software Requirements.

To learn more

Icon to represent SQL Server Mobile conceptsSQL Server Compact Concepts Provides conceptual information about SQL Server Compact that includes Getting Started and Overview information, SQL Server Compact concepts, task-based How-to topics and tutorials, and troubleshooting information.
Icon to represent SQL Server Mobile programmingDevelopment (SQL Server Compact) Provides information about how to build and deploy SQL Server Compact and samples.
Technical Reference (SQL Server Compact) Provides information about user interface reference (F1 help), managed and native programming references, SQL grammar reference, and the System.Data.SqlServerCe namespace, the managed data provider for SQL Server Compact.