[1] In February 2013 SQL Server Compact Edition had been deprecated; no new versions or updates are planned, although Microsoft continued to support the product until July 2021.
[4] It also includes ADO.NET providers for data access using ADO.NET APIs, and built-in synchronization capabilities,[2] as well as support for LINQ and Entity Framework.
[7] SQL CE databases can support ACID-compliance, but do not meet the durability requirement by default because AutoFlush buffers changes in memory (including enlisted ambient transactions and explicit SQL CE transactions that do not override the Commit() call with an CommitMode.Immediate value).
[14] The current release does not support stored procedures[4] or native XML data type either.
[citation needed] SQL Server Management Studio 2005 can read and modify CE 3.0 and 3.1 database files (with the latest service pack), but SQL Server Management Studio 2008 (or later) is required to read version 3.5 files.
Microsoft Visual Studio Express 2008 SP1 can create, modify, and query CE 3.5 SP1 database files.
[citation needed] The .sdf ("Sqlce Database File") naming convention is optional, and any extension can be used.
[citation needed] In February 2013, Microsoft announced that SQL Server Compact Edition had been deprecated.