How to refer to the SQLite database in Windows Phone8

Introduction to SQLite Database

1.SQLite is a lightweight embedded database, developed using C + +, with a very wide range of

2.SQLite is a cross-platform database that supports Windows, Linux, Android, IOS, Windows Phone Pack systems

3. SQLite in Windows Phone is an unmanaged component

4. You can use it in the Windows runtime or in a C # project

5. In a C # project, you need to access it through the Windows runtime components

Here's how to use SQLite to develop applications in WP

1. First we download the Database Tools installation package at the address: http://www.sqlite.org/download.html, find the download link for wp8 download and install, restart Visual Studio after installation, then we can menu > Tools > Extensions and tools to see the added components

2. Download the C + + project SQLITE-NET-WP8:HTTPS://GITHUB.COM/PETERHUENE/SQLITE-NET-WP8 project and add it to the project through vs Add Existing project as shown:

3. Open the console 4. Enter the command below and return to Install-package sqlite-net Here you will be prompted to add a success to automatically add two action classes in the project (if there is a case where the domain name nuget.org cannot be resolved, you can try several times) as shown in: 5. When you open the SQLite.cs file, you see the following: The first sentence If is SQLite support for C #, we choose here #elifUse_wp8_native_sqlite(c + + version, high efficiency), open the project properties, as shown, add conditional compilation Item 6. Finally add a project reference, reference the SQLite project to the Sqlitedemo project, and complete the reference work for SQLite in Windows Phone8, Below we can use SQLite to store data, the next section will mainly describe how to operate the SQLite database.