.NET framework 4.5 Applications
Targets supported: x86, and AnyCPU (with "Prefer 32-bit" option marked). Targeting x64 platform architecture is not supported at the moment.
  1. Prerequisite The developer visits http://sqlite.org/download.html, and downloads the required precompiled binary for Windows v3.8.5 (http://sqlite.org/2014/sqlite-dll-win32-x86-3080500.zip), extracts the sqlite3.dll file, and adds it as Copy-Always Content to the root folder of the project.
  2. In Visual Studio, the developer uses NuGet Packet Manager Console to install the SQLitePCL wrapper package.
    1. Inside the Package Manager Console, type: Install-Package SQLitePCL
  3. The developer selects the target compilation architecture in Visual Studio solution configuration window.
    1. When referencing the package from a runnable project, such as a Console Application or Windows Application, the developer should target x86 platform architecture, or Any CPU with Prefer 32-bit option marked.
    2. When referencing the package from a Class Library project, the developer should verify that the runnable project referencing the Class Library is targeting x86 platform architecture, or Any CPU with Prefer 32-bit option marked.

Windows Runtime 8.0, and 8.1 (Universal App) Applications
Targets supported: ARM, x86 or x64.
  1. Prerequisite The developer visits http://sqlite.org/download.html, and downloads the required extension SDK (VSIX package).
    1. Windows Runtime 8.0 requires the extension SDK SQLite for Windows Runtime v3.8.5, from the SQLite.org site (http://sqlite.org/2014/sqlite-winrt-3080500.vsix).
    2. Windows Runtime 8.1 requires the extension SDK SQLite for Windows Runtime (Windows 8.1) v3.8.5, from the SQLite.org site (http://sqlite.org/2014/sqlite-winrt81-3080500.vsix).
  2. In Visual Studio, the developer uses NuGet Packet Manager Console to install the SQLitePCL wrapper package.
    1. Inside the Package Manager Console, type: Install-Package SQLitePCL
  3. The developer selects the target compilation architecture in Visual Studio solution configuration window.
    1. "Any CPU" architecture is not supported, so the developer has to select the target compilation architecture and Visual studio will reference the appropriate extension SDK dll file when project compiles.

Windows Phone Silverlight 8.0 and 8.1 Applications
Targets supported: ARM or x86.
  1. Prerequisite The developer visits http://sqlite.org/download.html, and downloads the required extension SDK (VSIX package).
    1. Windows Phone Silverlight 8.0 and 8.1 require the extension SDK SQLite for Windows Phone v3.8.5, from the SQLite.org site (http://sqlite.org/2014/sqlite-wp80-winrt-3080500.vsix), has been properly installed.
  2. In Visual Studio, the developer uses NuGet Packet Manager Console to install the SQLitePCL wrapper package.
    1. Inside the Package Manager Console, type: Install-Package SQLitePCL
  3. The developer selects the target compilation architecture in Visual Studio solution configuration window.
    1. "Any CPU" architecture is not supported, so the developer has to select the target compilation architecture and Visual studio will reference the appropriate extension SDK dll file when project compiles.

Windows Phone Runtime 8.1 (Universal App) Applications
Targets supported: ARM or x86.
  1. Prerequisite The developer visits http://sqlite.org/download.html, and downloads the required extension SDK (VSIX package).
    1. Windows Phone Runtime 8.1 requires the extension SDK SQLite for Windows Phone 8.1 v3.8.5, from the SQLite.org site (http://sqlite.org/2014/sqlite-wp81-winrt-3080500.vsix), has been properly installed.
  2. In Visual Studio, the developer uses NuGet Packet Manager Console to install the SQLitePCL wrapper package.
    1. Inside the Package Manager Console, type: Install-Package SQLitePCL
  3. The developer selects the target compilation architecture in Visual Studio solution configuration window.
    1. "Any CPU" architecture is not supported, so the developer has to select the target compilation architecture and Visual studio will reference the appropriate extension SDK dll file when project compiles.

Xamarin Android
Targets supported: Any CPU
  1. Prerequisite SQLite is natively supported on Android.
  2. In Visual Studio, the developer uses NuGet Packet Manager Console to install the SQLitePCL wrapper package.
    1. Inside the Package Manager Console, type: Install-Package SQLitePCL

Xamarin iOS
Targets supported: Any CPU
  1. Prerequisite SQLite is natively supported on iOS.
  2. In Visual Studio, the developer uses NuGet Packet Manager Console to install the SQLitePCL wrapper package.
    1. Inside the Package Manager Console, type: Install-Package SQLitePCL
  3. You should make an explicit call to SQLitePCL.CurrentPlatform.Init() static method from your Xamarin iOS application, in order to have the platform specific SQLitePCL.Ext.dll library loaded into the package.

PCL Project
Targets supported: Any CPU
  1. Prerequisite
    1. If your PCL Project is part of another NuGet Package, you should add this NuGet package as a dependency.
    2. If your PCL Project is referenced from other platform specific host projects, you should install this NuGet package on each of these projects.
  2. In Visual Studio, the developer uses NuGet Packet Manager Console to install the SQLitePCL wrapper package.
    1. Inside the Package Manager Console, type: Install-Package SQLitePCL

Last edited Jul 2, 2014 at 1:34 PM by leotilli, version 8