How to use SQLite in Visual Studio 2017?

c# sqlite uwp visual-studio-2017 uwp-xaml
CorentinMerit picture CorentinMerit · Jan 25, 2018 · Viewed 34.7k times · Source

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

David Morrow picture David Morrow · Mar 10, 2019

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.

Related questions

Create SQLite Database and table

Within C# application code, I would like to create and then interact with one or more SQLite databases. How do I initialize a new SQLite database file and open it for reading and writing? Following the database's creation, how do …

Read More
Unable to load DLL 'SQLite.Interop.dll'

Periodically I am getting the following exception: Unable to load DLL 'SQLite.Interop.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) I am using 1.0.82.0. version, installing it with nuget in VS2010, OS Win7 64. Once exception …

Read More
What 'additional configuration' is necessary to reference a .NET 2.0 mixed mode assembly in a .NET 4.0 project?

I have a project in which I'd like to use some of the .NET 4.0 features but a core requirement is that I can use the System.Data.SQLite framework which is compiled against 2.X. I see mention of this being …

Read More