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).
SQL CE databases can be created and managed from Microsoft Visual Studio and some older versions of SQL Server Management Studio as well [REF].