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

[{'answer_id': 67411, 'author': 'John Rennemeyer', 'author_id': 5931, 'author_profile': 'https://Stackoverflow.com/users/5931', 'pm_score': 6, 'selected': True, 'text': '<p>Depending on the applications use, <strong>I would recommend using SQL Lite</strong> because it doesn\'t require you to install any other software (SQL CE or Express, etc. usually would require a separate install).</p>\n\n<p>A list of the most important benefits for SQL Lite from the provider link at the bottom of this post:</p>\n\n<blockquote>\n  <p>SQLite is a small C library that\n  implements a self-contained,\n  embeddable, zero-configuration SQL\n  database engine. Features include:</p>\n  \n  <ul>\n  <li>Zero-configuration - no setup or\n  administration needed.</li>\n  <li>Implements most of SQL92. (Features\n  not supported)</li>\n  <li>A complete database is stored in a\n  single disk file.</li>\n  <li>Database files can be freely shared\n  between machines with different byte\n  orders.</li>\n  <li>Supports databases up to 2 terabytes\n  (2^41 bytes) in size.</li>\n  <li>Small code footprint: less than 30K\n  lines of C code, less than 250KB\n  code space (gcc on i486)</li>\n  <li>Faster than popular client/server\n  database engines for most common\n  operations.</li>\n  <li>Simple, easy to use API.</li>\n  <li>Self-contained: no external\n  dependencies.</li>\n  <li>Sources are in the public domain.\n  Use for any purpose.</li>\n  </ul>\n</blockquote>\n\n<p>Since you\'re using WPF I can assume you\'re using at least .NET 3.0.  I would then recommend going to .NET 3.5 SP1 (sames size as .NET 3.5 but includes a bunch of performance improvements) which includes LINQ.</p>\n\n<p>When using SQLite, however, you would want to use the following SQLite Provider which should provide LINQ support: <a href="http://sqlite.phxsoftware.com/" rel="noreferrer">An open source ADO.NET provider for the SQLite database engine</a></p>\n'}, {'answer_id': 67424, 'author': 'Paul Dolphin', 'author_id': 10186, 'author_profile': 'https://Stackoverflow.com/users/10186', 'pm_score': 0, 'selected': False, 'text': '<p>I would agree that SQLite is the way to go.\nSubsonic 2.1 now includes SQLite support as well.</p>\n'}, {'answer_id': 67542, 'author': 'Allan Wind', 'author_id': 9706, 'author_profile': 'https://Stackoverflow.com/users/9706', 'pm_score': 2, 'selected': False, 'text': '<p>SQLite is a really nice product although I miss features from PostgreSQL.  There are other, especially non-SQL, databases you may to consider like Berkeley DB.</p>\n\n<p>/Allan</p>\n'}, {'answer_id': 75661, 'author': 'Bob King', 'author_id': 6897, 'author_profile': 'https://Stackoverflow.com/users/6897', 'pm_score': 3, 'selected': False, 'text': "<p>Just to throw out a differing opinion, we've been using SQL Compact Edition for the last year and have been generally satisfied with. The configuration is cake and it behaves very similar to a regular MS SQL database. There are things missing, like triggers and stored procedures, but SQL 3.5 CE has virtually everything else we'd need. It's about 2Mb of .dlls to install. It offers database encryption, transactions, and supports VS's typed dataset designer (3.1 had some problems, but CE 3.5 is great!).</p>\n"}, {'answer_id': 80143, 'author': 'AndrewS', 'author_id': 14982, 'author_profile': 'https://Stackoverflow.com/users/14982', 'pm_score': 4, 'selected': False, 'text': "<p>I used SQL Compact Edition with my WPF app and I'm happy with my decision. Everything just works (since WPF and SQLCE are both MS they play nicely together), and the installation of the runtime is small enough and smooth enough for my needs. I created and modified the database through visual studio.</p>\n"}, {'answer_id': 274950, 'author': 'Community', 'author_id': -1, 'author_profile': 'https://Stackoverflow.com/users/-1', 'pm_score': 2, 'selected': False, 'text': '<p>SQL CE DLLs can be packaged into your own application and need not require a separate install.  But MS provides a default install package, if you dont want to learn about setup ...etc.</p>\n\n<p>More ot it, SQL CE supports private deployment.</p>\n'}]
['https://Stackoverflow.com/questions/67127', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/1133/']