SQL Server Compact Edition 4 Announced

Scott Guthrie in his blog announced a new version of the compact database SQL Server Compact Edition 4 . SQL Server Compact Edition 4 is a free, embedded database engine that has been designed to work in ASP.NET web applications.

SQL Server Compact Edition 4 has the following features:

• works with the existing API, you can use ADO.NET, Entity Framework, NHibernate to work with SQL CE 4 databases;
• installation is not required, you do not need to install anything, just copy the database file to the appropriate folder and your application will be able to work with it. In addition, you do not need administrator rights to work with databases;
• To work with SQL CE4 databases, shared hosting scripts are supported. Hosters and developers do not need to do anything, everything just works;
• full support for the development and design of databases in Visual Studio 2010 and Visual Web Developer 2010 Express;
• Support for multi-threaded web application scripts and application in ASP.NET without licensing restrictions;
• simple migration to full-fledged SQL Server or SQL Azure, which will require the developer to simply change the connection string in the application;

The release of SQL Server Compact Edition 4 is scheduled for next week (along with IIS Express and a number of other new things).

We wait!