I have a following question. I am developing an application for a corporate customer where some data (a kind of a validation rule engine) would need to be stored. In phase 1, the data were not stored, but created as POCOs, so I have a hierarchical structure of subclasses. As a part of phase 2 (now), the customer would need to edit the rules locally, so they need to be dynamically stored. That should be a local file based database using EF6. In phase 3, the customer would provide a central DB server with either MS SQL Server or Oracle, which would replace the local DB.
The question is - which file based DB can I use? I considered SQLite, but it seems it can not be autofilled with the POCOs "Model first" way, or at least I have myriads of exceptions, missing tables, etc....
You can use SQL Server Compact, or SQL Server Express. SQL Server Express requires admin access to install as a service, SQL Server Compact does not.