See this answer: Database functionality with WPF app: SQLite, SQL CE, other?
– SQL Compact 4 has full support for Entity Framework, Linq to SQL
– Includes all neccesary file for private deployment
– has good tools support in Visual Studio 2010 and 2012
– has a smooth migration path to SQL Server