How to use SQLite in Visual Studio 2017?

Question

I'm using Visual Studio 2017, in UWP project. I installed SQLite Compact Toolbox from NuGet package like this:

• Microsoft.Data.sqlite / sqlite-net / sqlite-net-pcl / System.Data.SQLite

After that, I still can't add using Microsoft.Data.Sqlite in MainPage.xaml.cs to read values in my table and make a query.

How can I be able to add using Microsoft.Data.Sqlite?

Answer 1

Add SQLite/SQL Server Compact Toolbox from In Visual Studio 2017 Community. Goto Tools - Extensions and Updates - click Online. Search for Sqlite. You should see Sqlite compact toolbox. Click download . Restart visual studio.

Answer 2

Try using

using System.Data.SQLite;

Read more here https://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki

Answer 3

how to use sqlite in visual studio 2017

I'd recommend you to follow this latest tutorial to use a SQLite database in a UWP app.

And i can't add using Microsoft.Data.Sqlite

If you installed the Microsoft.Data.Sqlite Nuget package, but cannot reference the Microsoft.Data.Sqlite namespace, you may need to check the versions of UWP app,package and Microsoft.NETCore.UniversalWindowsPlatform. As the article mentioned,if the minimum version of your project does not target the Fall Creators Update, you need to upgrade Microsoft.NETCore.UniversalWindowsPlatform package to 5.2.2 (or higher) and install version 1.1.1 (or lower) of Microsoft.Data.Sqlite package. Details please check The minimum version of your project does not target the Fall Creators Update section.

There're many Nuget packages for SQLite, some of them are older with long time no updating. Install many packages at a same time may lead conflicts.Try un-install them all and just following above tutorial.

There is a sample which use the old SQLite.Net-PCL package you could also reference if you do want to use other packages.