I am trying to make a tiny application, using SQLite and EF6.
I already have an SQLite database with tables and data, so I want to create a model and populate it from that. However despite everything I've tried I have had no success.
When adding a new "ADO.NET Entity Data Model" I have no option for SQLite database (this is on Visual Studio 2015).
I already saw this, this and this.
What I have done so far:
- First tried to simply install SQLite by NuGet - no luck.
- Then I created a new project, and instead of NuGet installed the latest x32 System.Data.SQLite setup package and made sure to check the option of installing design-time components for Visual Studio 2015 - no dice
- Then I saw someone had luck with installing an older version of the setup packages. After a painstaking installation (after removing the newer version) - no cigar.
- So I started following this one and, hooray - I can't add the assemblies, despite telling the setup to put them in the Global Trash Can or whatever.
So I come to you, dear people, hoping someone can wave a magic wand and help me get this thing that's supposed to be tiny, fast and easy to be, you guessed it - at all working.