SQL Compact 3.5 SP1 will contain quite a number of new features. This Service Pack will be released together with Visual Studio 2008 SP1/.NET Framework 3.5 SP1.
The release of SQL Compact 3.5 SP1 will contain the following new features on top of a number of bug fixes:
- Support for x64 both on the runtime and server tools. (Will be made available as a web download when VS 2008 SP1 is released. Steve Lasker blogs in detail about the support for this new platform.
- Support for Entity Framework and Entity SQL. Ravi Tandon has more info on the SQL Compact blog. This support is for desktop only - not devices.
- Support for "Local Database Cache" for device projects (currently available as a CTP). This means that Microsoft Synchronization Services for ADO.NET is now available for devices.
- The Server Tools (for Merge and RDA) will fully support SQL Server 2008.
UPDATE 15/5 2007: The SP1 beta is now available for download, and Steve Lasker has more details about the SP1 changes and features.