VS 2015 SQLite data provider

sqlite dataprovider visual-studio-2015
TotPeRo picture TotPeRo · Feb 13, 2015 · Viewed 26.4k times · Source

I'm using VS 2015 and i want to develop Win Form application with .NET Framework 4.5 and SQLite.

I have install the last "System.Data.SQLite" nuget package with all dependencies to my project but I couldn't find the SQLite data provider when I was trying to add a new connection to manage my database.

I try the solution for VS 2013 from here but don't works.

there is still no bundle for VS 2015, this is the problem? is any solution to use 2013 bundle in 2015, or other solutions?

Answer

Daniel Kreiseder picture Daniel Kreiseder · Nov 17, 2015

Installing this package: sqlite-netFx46-setup-bundle-x86-2015-1.0.103.0.exe should fix that. You need specifically 32-bit version

From http://system.data.sqlite.org/:

This is the only setup package that is capable of installing the design-time components for Visual Studio 2015.

This is working link at the time of writing http://system.data.sqlite.org/downloads/1.0.103.0/sqlite-netFx46-setup-bundle-x64-2015-1.0.103.0.exe

will add sqlite to the server explorer in VS2015

Related questions

missing SQLite data provider in VS 2013

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

Read More
Select first row in each GROUP BY group?

As the title suggests, I'd like to select the first row of each set of rows grouped with a GROUP BY. Specifically, if I've got a purchases table that looks like this: SELECT * FROM purchases; My Output: id | customer | total …

Read More
How to list the tables in a SQLite database file that was opened with ATTACH?

What SQL can be used to list the tables, and the rows within those tables in an SQLite database file - once I have attached it with the ATTACH command on the SQLite 3 command line tool?

Read More