·
2 min read

Microsoft SQL Server Compact 4.0 is available for download and use with WebMatrix

The SQL Server Compact team is happy to announce that the next version of Microsoft SQL Server Compact 4.0 has been released, and is available for download and for use in the production systems at the location below:

http://www.microsoft.com/sql/compact
SQL Server Compact 4.0 has been designed, developed, tested and tuned over the course of last year and the release has been also vigorously verified by the vibrant MVP and developer community. The feedback from the developer community has helped to improve the quality of the SQL Server Compact 4.0 release and the Compact team would like to thank all the members of the community who participated in the release.
SQL Server Compact 4.0 and WebMatrix

·         Default database for Microsoft WebMatrix: Compact 4.0 is the default database for Microsoft WebMatrix, which is the web stack that encapsulates all the technologies like ASP.NET, IIS Express, Editor and SQL Server Compact that are needed to develop, test and deploy ASP.NET websites to third party website hosting providers.

·         Rapid website development with free, open source web applications: Popular open source web applications like mojoPortal, Orchard, Umbraco etc. support Compact 4.0 and can be used to rapidly develop, test and deploy websites.

·         One click migration to SQL Server: As the requirements grow to the level of enterprise databases, the schema and data can be migrated from Compact to SQL Server using the migrate option in the WebMatrix IDE. This also adds a web.config xml file to the project that contains the connection string for the SQL Server. Once the migration completes, the website project seamlessly switches from using Compact to SQL Server.

·         ADO.NET Entity Framework 4 (.NET FX 4) code-first and server generated keys: Compact 4.0 works with the code-first programming model of the ADO.NET Entity Framework. The columns that have server generated keys, like identity and rowguid for example, are also supported in Compact 4.0 when used with ADO.NET Entity Framework 4.0. Support for the code-first and for the server-generated keys rounds out the Compact support for ADO.NET Entity Framework.

·         Improvements for setup, deployment, reliability, and encryption algorithms: The bases of Compact 4.0 have been strengthened to ensure that it can be installed without any problems, and can be deployed easily, and works reliably while providing the highest level of security for data.

WebMatrix Launch
WebMatrix v1 is ready to go, and starting Thursday, January 13, you’ll be able to download it from http://www.microsoft.com/webmatrix
WebMatrix makes it easy for anyone to create a new web site using a template or an existing free open source application, customize it, and then publish it on the internet via a wide choice of hosting service providers.  And yes, it’s free. 
WebMatrix lets you create web sites the way that you want to. We’ve spoken with countless web developers, and have learned what they want to create the next generation of web sites.
The main launch event for WebMatrix is CodeMash  on January 13th.  Microsoft will be simultaneously holding a live steaming event called Enter the WebMatrix, from http://microsoft.com/web/enter. This live event will be streamed as both an HD Smooth Stream as well as WMV for non-Silverlight users. The event starts with a one hour keynote where WebMatrix is introduced and demo’ed.  Features will be highlighted as will special partners that have built special Helpers or Web Applications available within WebMatrix.