SQL Server Compact 4.0 vs. SQLite

sqlite sql-server-ce
AVP06 picture AVP06 · Jan 29, 2011 · Viewed 40.2k times · Source

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!

Answer

ErikEJ picture ErikEJ · Jan 30, 2011

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

Related questions

SQL Server CE 4.0 performance comparison

SQL Server CE 4 (SQL Server Compact Edition 4.0) is not news already (If it is, you could read this article) But it is very interesting to see SQL Server CE 4 performance comparison to other databases. Especially with: SQLite SQL Server (1) SQL …

Read More
Database functionality with WPF app: SQLite, SQL CE, other?

I want to extend a WPF application with database functionality. Which database engine would you suggest and why? SQLite, SQL CE, other?

Read More
Best way to export SQL Server database to sqlite (or SQL Server Compact)

Do someone know what would be the best way to transform a big SQL Server database to sqlite or SQL Server compact ? SQL Server database should be around 50-70Gb. There are some examples on internet (script schema) but I …

Read More