SQL Server Compact 4.0 vs. SQLite

Question

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!

possible duplicate of [Database functionality with WPF app: SQLite, SQL CE, other?](http://stackoverflow.com/questions/67127/database-functionality-with-wpf-app-sqlite-sql-ce-other) — nawfal, Feb 21 '13 at 09:00
Sqlite now works with EF and Linq to SQL, and there is a nuget package that supports migrations. — brandonstrong, Feb 28 '20 at 17:08

score 32 · Accepted Answer · edited May 23 '17 at 12:26

32

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

edited May 23 '17 at 12:26

Community

1
1

answered Jan 30 '11 at 11:01

ErikEJ

40,951
5
75
115

10

That answer doesn't really apply to SQL CE 4.0. as SQL CE 4.0 now has almost all of the benefits that answers mentioned about SQLite. – kay.one Jun 15 '11 at 02:00
1

SQL Compact 4 isn't fully supported in all version of visual studio. Try using it with c# under visual studio express. – Jan 22 '12 at 13:21
7

Broken link on the referred answer. – Jorge Galvão Dec 17 '13 at 23:22
Link to answer is bad – Matt Watson Jan 19 '14 at 13:46
1

Sqlite now works with EF and Linq to SQL, and there is a nuget package that supports migrations. – brandonstrong Feb 28 '20 at 17:08

SQL Server Compact 4.0 vs. SQLite

1 Answers1

Linked