0

I am trying to install SQLite with no success. I have tried installing it through NuGet Package manager,

Tried installing http://system.data.sqlite.org/downloads/1.0.98.0/sqlite-netFx46-setup-bundle-x86-2015-1.0.98.0.exe

and http://system.data.sqlite.org/downloads/1.0.101.0/sqlite-netFx46-setup-bundle-x86-2015-1.0.101.0.exe

but every time I go to Server Explorer > Data Connections > New Connection SQLite is not listed in the Data Source window:Choose Data Source Window

keeg
  • 3,990
  • 8
  • 49
  • 97

1 Answers1

4

Please install the sqlite-netFx46-setup-bundle-x86-2015-1.0.98.0.exe (the first link you provided) with the “Install the designer components for Visual Studio 2015” option checked. I don’t check it when my first time install, so I get the same result that there doesn’t have SQLite provider in Data Source list.

But after I reinstall with the install the designer components option checked and restart Visual Studio. I could choose SQLite database file option in Data Source list.

enter image description here

Weiwei
  • 3,674
  • 1
  • 10
  • 13
  • Thank you that did the trick. That was so frustrating. I did not notice this checkbox, though even if I did it's not very well explained. – keeg Sep 05 '16 at 15:55
  • it worked but I've had to uninstall SQLite versions for older Visual Studio. Thanks – Ivan Ferrer Villa Oct 18 '18 at 16:38