Windows Phone 8.1 Development SQLite Database Reference installation

Source: http://www.bcmeng.com/windows-phone-sqlite/

Windows Phone 8.1 Development SQLite Database Reference installation

• The first step:

Install the SQLite forwindows Phone 8.1 plugin:

Plugin: http://visualstudiogallery.msdn.microsoft.com/5d97faf6-39e3-4048-a0bc-adde2af75d1b

After you go to download the installation, restart VS2013, and add references, you will find the SQLite forwindows Phone 8.1 SDK in the Windows Phone 8.1 extension option.

• Step Two:

After referencing the SQLite forwindows phone 8.1 SDK, Microsoft Visual C + + Runtime package will appear for Windows phone and SQLite forwindows Pho NE 8.1 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".

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.

At this point, the installation is complete, start working on the SQLite database now!

Windows Phone 8.1 Development SQLite Database Reference installation