
Creates a table based upon the message model we created in step 6.
Locate the SQLite file will be using to store the data (SQLite will automatically create it). Go to the code behind the Mainpage.xmal and add the following. Please note that to make use of these attributes you must add the following reference. The only difference between a regular model and one being using for SQLite is that we have to add some additional attributes, for example: This model is translated into a table within our local database. Now we need to create a model for the data that we want to store with SQLite. 5.Update mainpage.xamlįirst let’s create the UI for this universal application. The reference can be found under Windows Universal -> Extensions. Run the following commands in the Package Manager Console:Īdd the following required references from the SQLite extension installed in Step 2: 2.Install the SQLite Visual Studio extension for Visual Studio 2015ĭownload and install the pre-release version of SQLite Visual Studio extension for Visual Studio 2015 RC which can be found here.Īt the time of writing this blog post, the VSIX package for Universal App Platform development is in beta. In this tutorial, the Windows 10 universal application I create will be called SQLitePiExample. It has had a large impact on game and mobile application development, due to its portability and small footprint.
SQLite Database Engine is a process library that provides a serverless (self-contend) transactional SQL database engine. Do you need a lightweight reliable database? Does it need to work without an internet connection? Do you want to save yourself a mountain of configuration…Then the answer is SQLite! What is SQLite