SQL Server Compact 4.0 vs. SQLite
I'm interested in choosing an embedded DB engine for my WPF app. I would like information on how SQLite and latest SQL CE 4.0 compare. And if I should choose one over the other. Points of interest would be ORM support with EF4's CTP & NHibernate 3.
Thanks in advance!
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