C# - Best Database system for small local apps

I know these question has been asked before. However, most of them are from before 2013 and since then much has changed. Here is my plight: I have a small project to organize some RPG stuff (characters, locations, events, etc.) Up until now I store everything in plain JSON files on the hard drive. Now I want to move away from that to a Database.

Now I ask myself: What is the best choice? Most of what I found was: "Use SQLite!" And currently I am doing that. But I have some problems with it. I can connect to the database I created and insert objects in it, but when I later open the database with SQLiteAdmin I get an empt database.

I understand that SQLite has no full support for EF6 yet. Now I am wondering if there is an alternative? SQLServer CE is being dropped by Microsoft so it is no option for me. Could the regular SQL Server with LocalDB be a solution, or would that be too much overkill? Suggestions?