First we’ll create a simple table called Team. The SQLite.NET-PCL NuGet package Bringing it all TogetherĪnd here’s how we can use this library in code. I personally decided to go with SQLite-Net.PCL for a few key reasons: it’s an active project on GitHub and is a PCL (portable class library). NET friendly wrapper for it and there are a ton to chose from. The reference you need to add to your project SQLite PCLĪt this point you’ve got the main DLL on your system and your project is referring to it. In the window that pops up select Universal Windows > Extensions > SQLite for Universal App Platform. In your project, right click References and select Add Reference. Adding SQLite Service Reference to Your Project SQLite VSIX available via Visual Studio 2015 Extensions and UpdatesĪs you can infer from the above picture, you can know you have it installed by checking your installed extensions. In the search field on the right, enter SQLite for Universal App Platform and you will see it in the list. The second method is open Visual Studio 2015 > Tools > Extensions and Updates > Online tab. This name was changed to UWP before Windows 10 went RTM. Note the “UAP” name (Uniersal App Platform). If you go here, you will find it under the Universal Windows Platform header. The first is to go to and download the VSIX. Since it’s a VSIX, Visual Studio will remind you when an update is available. It’s delivered as a VSIX (Visual Studio Extension Installer). The first step is ensure the SQLite for Universal Windows Platform is installed. In Visual Studio Code, set the language mode to SQL to enable mssql commands and T-SQL IntelliSense. This post explains how we can add it (summary: there’s a few steps but it’s all straightforward).
In the UWP platform, Microsoft is encouraging us to all use SQLite as the local database.
0 kommentar(er)
