Up to the older versions of Visual Studio, the option to create a local database ("Local Database") was available. However, in the 2017 version, there is no longer this possibility. Apparently Microsoft would be removing support for it.
Would you know of any installation or alternative options for SQL Server CE? It would be helpful if you did not need an additional installation (like LocalDB) or a monstrous setup to work with EF6 (like SQLite).
I have already used SQlite as an alternative and I say that its configuration is not complex, I have already used Entity and it runs fine, it still does not work the code first, it has to change via script the changes that roll in the mapping model, but it works well and is not complicated. No need to install it, just by adding the nuget package in your application to SQLite. Same configuration as you would for sql. This project I use SQLite, take and study, will realize that it is simple:
