AVP06
Reputation: 1079
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!
Upvotes: 53
Views: 45407
Answers (1)
ErikEJ
Reputation: 41749
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
Upvotes: 32
Related Questions
- Best way to export SQL Server database to sqlite (or SQL Server Compact)
- T-SQL differences between SQL Server Compact Edition and real SQL Server?
- How to get started with SQL Server Compact 4.0?
- SQL Server CE 4.0 performance comparison
- Disadvantages of using SQL Server Compact versus dedicated SQL Server database
- SQL Compact 4.0 Tools
- Advantages and Disadvantages of SQLite.NET and SQL Server Compact
- SQL Server CE 4.0
- Is SQL Server Compact Edition a sensible alternative to SQLite?
- Which Database to use for CMS project in ASP.NET - SQLite or SQL server compact?