You know about normal SQL databases and wanna start playing around with SQLite and have a rough understanding what SQLite is. For working with it you desire to use EF from the start on. And you want to use the "Database First" Approach and create your model the sqlite database. Thats how I wanted to do it. Unfortunately, using DB-first approach with sqlite is very tricky and volatile. I managed to do it... only to find that 2 months later my Visual Studio wasnt able to do the same thing again because the "Data Provider" inside my visual studio had forgotten the installed sqlite... and i needed to do the procedure again. so my actual suggestion is.... if you want to use SQLite with EF then.... don't. Seriously . For now, for small applications I need a local DB started to use Dapper together with SQLite instead and use Code-First. Its really much easier. If you follow the steps in this excellent article during reading you will have a working ORM solution