If SqLite does not show up on the server explorer even after installing System.Data.Sqlite package in Visual Studio 2015,
You’ve just got a couple steps backwards.
The issue is that the System.Data.Sqlite package includes VC++ Update 2, but you’ve already got the newer Update 3 installed. Rather than recognize there’s already a newer version installed, all the setup program sees is that installing U2 failed and bails out. So, we need to let it do its thing and install the U2 package to get past that point:
Uninstall “Microsoft Visual C++ 2015 Redistributable (x86) – 14.0.24212”
Install the Sqlite package
THEN re-install Update 3