The first step:
To install the SQLite for Windows Phone plugin:
Plugin: http://www.sqlite.org/download.html
Name of the Windows Phone 8 plugin after download: sqlite-wp80-winrt-3080803.vsix
Name of the Windows Phone 8.1 plugin after download: sqlite-wp81-winrt-3080803.vsix
After you go to download the installation, restart VS2013, and then add a reference, you will find the SQLite for Windows Phone in the extended options of Windows Phone, reference.
Step Two:
After you reference the SQLite for Windows Phone SDK, the Microsoft Visual C + + Runtime package for Windows Phone and SQLite for Windows Phone will appear components, but you'll find that they have yellow icons on their images. The compilation failed.
Error message:
Error 1 references the SDK "any CPU" does not support the processor architecture of the project being built "Microsoft.vclibs, version=12.0". Consider changing the project's target processor schema to a schema supported by the SDK (in Visual Studio, this can be done through Configuration Manager): "x86, ARM".
Error 2 references the SDK "any CPU" does not support the processor architecture of the project being built "sqlite.wp81, version=3.8.5". Consider changing the project's target processor schema to a schema supported by the SDK (in Visual Studio, this can be done through Configuration Manager): "x86, ARM".
Error 2 references the SDK "any CPU" does not support the processor architecture of the project being built "SQLITE.WP80, version=3.8.8.3". Consider changing the project's target processor schema to a schema supported by the SDK (in Visual Studio, this can be done through Configuration Manager): "x86, ARM".
The workaround is to change any CPU to x86 or arm in Configuration Manager, but if you want to debug the machine, you must configure it as arm.
Step Three:
Right-click Solution Manager, select Manage NuGet packages, and search online for SQlite. Select the first item in the result: sqlite-net;
Installation can be done. After successful installation, you will find two more CS files: SQLite.cs and SQLiteAsync.cs.
If the SQLite.cs and SQLiteAsync.cs compilations fail, it is because the SQLite reference is also missing in the NuGet package download.
Caveats: Conditional Compilation symbols
Note: Missing sqlite for Windows phone reference, compile will not error, but run and create the database will be error. The following is the final reference.
At this point, the installation is complete, start working on the SQLite database now!
Article Source: http://ject.club/windows/
Windows Phone 8.1 Development SQLite Database Reference installation