Using SQLite-NET with UWP

sqlite visual-studio-2015 windows-10 sqlite-net uwp
Kinani picture Kinani · Aug 6, 2015 · Viewed 10.6k times · Source

I downloaded the package from NuGet and still there's no SQLite.cs neither SQLiteAsync.cs added to the project, If SQLite-NET is still not supporting VS 2015 RTM, Any possible alternatives?

Note that I tried SQLite.NET-PCL and still the same problem.

Answer

Igor Ralic picture Igor Ralic · Aug 6, 2015

SQLite.NET-PCL shouldn't add those two classes directly to your project files.

Did you download the right SQLite.NET-PCL via NuGet? (there's a huge mess when you search for SQLite.NET on NuGet so it's easy to get confused and install the wrong one).

The right SQLite.NET PCL library

Did you install the SQLite VSIX package for Universal App Platform development using Visual Studio 2015. Did you add it to your project references?

Have you tried reading my blog post on this topic: Using SQLite in Windows 10 Universal apps?

Everything should work OK with VS 2015 RTM.

Related questions

VS 2015 SQLite data provider

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 …

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