CODEWITHSUNDEEP
databasesqliteentity-framework-6ef-model-first
Petr Osipov
Petr Osipov

Reputation: 619

EF6 - which file based database

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....

Upvotes: 0

Views: 167

Answers (1)

ErikEJ
ErikEJ

Reputation: 41759

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.

Upvotes: 1

Related Questions