Missing ADO.NET Data Source for sqlite in Visual Studio 2015

Question

I looked at other old topics and none of the answers helped me. I am using Visual Studio 2015. I grabbed the latest sqlite 1.0.97.0 and Entity Framework 6.1.3, and the ADO data source is not specified as an option for the ADO.NET entity data model. I have tried several different versions of the entity structure and sqlite. I also tried several versions of the .net framework (4.5 and 4.5.1). Curious if anyone has any suggestions or saw this.

Answer 1

You need to wait for version 1.0.98, for the next week https://system.data.sqlite.org/index.html/doc/trunk/www/news.wiki

Answer 2

Links to the exact version deprecated every time. So, instead of trying the direct download link, go here https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki (rather dirty) and find the line below on the page

---

This is the only installation package that can install development-time components for Visual Studio 2015.

---

You need to download this file.
Alternatively, you can change the VS version in your search bar.

Answer 3

I had to install this: http://system.data.sqlite.org/downloads/1.0.101.0/sqlite-netFx46-setup-bundle-x86-2015-1.0.101.0.exe

Then I was able to select sqlite data source in VS 2015

Link to the latest releases here https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki