22

I'm using VS 2013 to develop Win 8.1 app. I chose to deal with SQLite but I coudn't find the data provider when I was trying to add a new connection to manage my database.

Any help is appreciated

Zuzu JH
  • 607
  • 2
  • 10
  • 22
  • 3
    I would like to add something to JDL answer : as my windows is x64, I've installed the related version (sqlite-netFx451-setup-bundle-x64-2013-1.0.94.0) and it didn't work : no new connector in VS. As VS is 32 bits application, I was wondering if it could be related. So I tried the x86 one and got my answer, it was now ok : even on a x64 system, the version to install to enable VS designer support is the x86. Good to know !! – AFract Feb 26 '15 at 17:50

2 Answers2

36

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

I have lost 3 hours with this problem

Updated with new version. Updated with sanuel-jackson's comment info.

JDL
  • 700
  • 5
  • 16
  • 4
    Not sure if it makes a difference, but I checked the box "Install the designer components for Visual Studio 2013" and it worked for me. – jlunavtgrad May 05 '14 at 19:44
  • 7
    installed, rebooted, still can't seem to get vs2013 to show it in new item or connections dialog.. – Sonic Soul May 19 '14 at 22:17
  • 9
    As my windows is x64, I've installed the related version (sqlite-netFx451-setup-bundle-x64-2013-1.0.94.0) and it didn't work : no new connector in VS. As VS is 32 bits application, I was wondering if it could be related. So I tried the x86 one and got my answer, it was now ok : even on a x64 system, the version to install to enable VS designer support is the x86. Good to know !! – AFract Feb 26 '15 at 17:47
  • 6
    I can confirm that it doesn't always work. I've got a Win 8.1 64-bit machine with VS 2013. Running this link or the latest 1.0.96.0 link DOES NOT add the SQLite provider to the provider list when trying to connect via Server Explorer. – Jason Butera Apr 07 '15 at 16:51
  • Current version as of writing this is located here >> http://system.data.sqlite.org/downloads/1.0.98.0/sqlite-netFx451-setup-bundle-x86-2013-1.0.98.0.exe – Kraang Prime Sep 28 '15 at 12:54
  • Couldn't get any of these Sqlite installations to reveal the tools in 64 bit win 7 VS2015 – Ben Winding Apr 04 '16 at 03:12
  • Whoops, It actually just appeared!... removing the old references in the App.config file and reinstalling the NuGet packages helped I think ... Also for me it only shows when you select: Server Explorer > Data Connections > xxxxxx.mdf > (right click) Modify Connection > Change – Ben Winding Apr 04 '16 at 03:31
  • I added explained solution for this issue here: https://stackoverflow.com/questions/10215488/sqlite-not-in-list-of-visual-studio-data-source-options/41766336#41766336 – E235 Jan 20 '17 at 15:04
11

http://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki

and download Setups for 32-bit Windows (.NET Framework 4.5.1) where This is the only setup package that is capable of installing the design-time components for Visual Studio 2013.

Cyclion
  • 738
  • 9
  • 9