Announced SQL Server Compact Edition 4

Scott Guthrie in his blog announced a new version of the compact database of SQL Server Compact Edition 4 . SQL Server Compact Edition 4 is a free, embeddable database engine that was designed, among other things, to work in an ASP.NET web application environment.

SQL Server Compact Edition 4 has the following features:

• works with 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, you only need to copy the database file to the appropriate folder and your application can work with it. In addition, you do not need administrator rights to work with databases;
• For 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 use in ASP.NET without licensing restrictions;
• simple migration to a full 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!