We help IT Professionals succeed at work.

How to connect to an SQLite database in Visual Studio

Hi
I have Visual Studio community 2015 Update1 running on windows 7 64bit


This page only seems to provide links to 2015 update 3

Once I've installed the correct extensions and added to my first DB project using a windows application
how do I show  the results of a query on a user form?
Comment
Watch Question

Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016
Commented:
Hi trevor,
For this you need to follow the steps , pls refer this - https://swinbrain.ict.swin.edu.au/wiki/Using_SQLite_within_Visual_Studio

Basically 3 steps-

1. Download the ado.net provider
2. Connection to sqllite DB
3. Use the connection

Author

Commented:
The link you provided points to a version of ADO no longer supported this  in turn points to the the download page in my opening remarks

I've attempted to  install sqlite-netFx46-setup-bundle-x64-2015-1.0.106.0.exe  from that page but don't have the required data connectors in visual studio

iSqliteADO.JPG

Author

Commented:
Maybe I've not asked correctly

Which version of System.Data.SQLite do I need
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
I think you should use the latest version.

Author

Commented:
I think you should use the latest version.

I did and I'm no further forward
I've fixed this myself


Found this page it says to find the reight version with

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

for me its the Setups for 32-bit Windows (.NET Framework 4.6)

sqlite-netFx46-setup-bundle-x86-2015-1.0.106.0.exe
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016

Commented:
glad you got it. Cheers.
Top Expert 2016

Commented:
for me its the Setups for 32-bit Windows (.NET Framework 4.6)

Visual Studio itself is a 32-bit windows application. you can verify that it installs under 'Program Files (x86)'. nevertheless you could use VS to create 64-bit applications (a similar thing happened 25 years ago when vs went from 16-bit to 32-bit). so all tools and wizards and dll's around VS are 32-bit windows programs as well because 32-bit modules cannot be mixed with 64-bit and vice versa.

Sara

Author

Commented:
Expert solution didn't solve the problem  I did

In this context I'm being generous saying he assisted, read entire question for further details