SQLite for Windows Phone


SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

(12) Review
Visual Studio
2015, 2013, 2012
Download (92,316)
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Reviews (12)
Q and A (9)
Sign in to write a review
Sort by:

by Dušan Todorović | May 28 2015

by kamus27 | October 29 2014

by Ed (DareDevil57) | August 14 2014

Thank you

by Patil Nitin | July 19 2014

How to Store data or variables using SQLite in Windows Phone App ???


by Ricky_Brundritt | June 30 2014

by hppDev | April 15 2014

Often used in WP8 and Store apps. Hope to see a WP 8.1 version soon.

by caxep | April 07 2014

Add windows phone 8.1 support

by Vitaliy.Leschenko | April 05 2014

Please add support for Windows Phone 8.1

by Ryan Groom | April 13 2013

Using it for W8, Monotouch and Mono for Android. Works great. Thanks for porting to WP8.

by Louy Alakkad | March 31 2013

Useless without a wrapper (sqlite-net-wp8).
However the latest update isn't compatible with the wrapper and so it's now useless.

by David Tosi | February 26 2013

Need to add https://github.com/peterhuene/sqlite-net-wp8 to the mix and then sqlite-net works like a champ!

by CUMT1 | December 14 2012

dont know how to use

Sign in to start a discussion

  • Upgrading extension breaks sqlite-net-wp8
    2 Posts | Last post October 19, 2014
    • Everytime there's an upgrade to this extension, the SQLite NuGet has to be upgraded, which lately happens with significant delay. The issue for me is that after upgrading the extension, all of the projects I'm working on, that use SQLite, break.
      I tried embedding sqlite-net-wp8 and bumping the version manually which worked, but not for cases, when some NuGets depend on the sqlite-net-wp8 NuGet. It seems to me that building every such project manually defeats the purpose of having a dependency manager.
      I'm currently developing for Windows Phone, Android and iOS (both using Xamarin) and only Windows Phone has the process of setting up the SQLite so fragile, which is a shame since I really enjoy developing for this platform.
      I would like to suggest two solutions, that, if possible to implement, might make setting up SQLite on Windows Phone a little bit easier:
      - allow developers to download previous versions of the extension
      - combine the extension with sqlite-net-wp8, since in order to use the extension in Windows Phone apps we need sqlite-net-wp8 anyway and it needs to be updated along with extension
      Implementing at least one of those solutions would of great help.
    • How do you download the 3.8.6 version? Is there a link for that ?  I just upgraded to 3.8.7, and I'm getting:
      Warning	5	The type 'SQLite.TableAttribute' in 'c:\Users\Steve\Documents\Visual Studio 2013\path_to_my_project\SQLite.cs' conflicts with the imported type 'SQLite.TableAttribute' in 'c:\Users\Steve\Documents\Visual Studio 2013\ ... \SQLiteWP8\Bin\x86\Debug\SQLiteWP8.dll'. Using the type defined in 'c:\Users\Steve\Documents\Visual Studio 2013\checkncelebrate\CheckNCelebrate\CheckNCelebrate\SQLite.cs'
  • vacuum supported?
    2 Posts | Last post June 24, 2014
    • is executing the vacuum statement supported, doesn't seem to work... if you have a code snippet that works that I could try that would be great
      var db = new SQLiteWinRT.Database(filePathX);
      await db.OpenAsync(SQLiteWinRT.SqliteOpenMode.OpenOrCreateReadWrite);
      await db.ExecuteStatementAsync("vacuum;");
      "System.Exception: Invalid advise flags (Exception from HRESULT: 0x80040001 (OLE_E_ADVF))\r\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n   at System.Runtime.CompilerServices.TaskAwaiter.GetResult()\r\n   at APNO.HH.DAL.DbUtils.<UploadDatabase>d__0.MoveNext()"
    • Hello,
      Did you figure out what was the issue. I got the same issue when I added SqliteWinrt reference to windows phone project. I appreciate your help !!
  • Support for Visual Studio 2013
    5 Posts | Last post May 19, 2014
    • Please add support for visual studio 2013. I try to find it in the extension windows but there is no such results for this extesnion in the new visual studio. Best regards.
    • I, too, humbly request an update for VS 2013. In the meanwhile, you can manually download the VSIX package from http://www.sqlite.org/download.html and install it. Afterwards it should appear in the list of installed extensions in VS 2013.
    • Guys, we need the support for VS2013, there is one for VS2013 - SQLite for Win 8.1 so it shouldn't be hard?
    • We are waiting SQLite support for Windows Phone 8 in the VS 2013 like SQLite for Win 8.1 support.. Please be quick for this update..  
    • What's taking you so long?! Pretty sure it's easy to add support for VS 2013?!
  • If you don't see SQLite/WP in your VS2013 "Add Reference" dialog
    3 Posts | Last post March 17, 2014
    • When I ran VS2013 I didn't see the SQLite extension in the Windows -> Extensions list of references.  However I did see it when I ran VS2012.  Here's what I had to do see SQLite for Windows Phone in the that references list:
      * Make a backup of the SDKExtension manifest file and modify it to change the minimum supported version from "11" to "12".  Note, this may cause problems for VS2012, I haven't tested it yet.  I also added a FileReference tag to reference the sqlite3 DLL just to be safe.    On my system the manifest file is here:
      C:\Program Files (x86)\Microsoft SDKs\Windows Phone\v8.0\ExtensionSDKs\SQLite.WP80\
      * Edit the file by opening a command prompt windows (cmd.exe) with *administrator priveleges* and edit the file SDKManifest.xml by running Notepad from the command line.  Here's the updated file contents that worked on my system:
      <?xml version="1.0" encoding="utf-8" ?>
          DisplayName="SQLite for Windows Phone"
          <File Reference="sqlite3.dll"/>
      Close and save the file. That should get the SQLite for Windows Phone 8 extension to show up in the Windows Phone -> Extensions list.
      NOTE: You still need to install the SQLite-net NuGet package to be able to work with the SQLite DLL.  The extension just makes sure the correct SQLite dll is included in your app depending on your build configuration.  If you get a Yellow Exclamation mark next to the SQLite for Windows Phone reference in your project, try changing your Build configuration to x86 to make it go away.
    • To be specific you need the sqlite-net-wp8 NuGet package.
    • I need to clarify my answer.  After adding a reference to the "SQLite for Windows Phone" extension in your project, you need to add the "sqlite-net" NuGet package to your project first, and then the "sqlite-net-wp8" NuGet package.  Make sure you follow the instructions on the sqlite-net-wp8 page, especially the part about adding USE_WP8_NATIVE_SQLITE to your project conditional defines:
      If you can't find the SQLite.cs and SQLiteAsync.cs source files in your project after doing that, then in the Solution Explorer pane press the "Show All Files" button and then the "Refresh" button.  For some reason in my case, the files were added to my hard disk but not included in the project.  Just highlight the two files, right click, and choose "Include in Project".  That should get you a project that builds.
  • v3.8.2 - Can't perform update statement
    1 Posts | Last post December 09, 2013
    • Hello,
      I just updated to v3.8.2 and now when I attempt to update an object in the db, I get an exception with the following message: "SQL logic error or missing database".
      Is there any way that I can downgrade, or can you please fix this ASAP...
      Note, I am using the sql-net-wp8 package along with sql-net C# wrapper.
  • This extension is not available within Visual Studio 2013
    1 Posts | Last post November 12, 2013
    • Hi,
      this extension is not available within "Extension and Updates" within Visual Studio 2013 and when I convert a project from Visual Studio 2012 that requires this extension it doesn't run.  Can you tell me when this extension will be available from within Visual Studio 2013?
  • VS2013 RTM Ultimate
    1 Posts | Last post October 19, 2013
    • After install in VS2013 RTM Ultimate, I've added a SqlLite wrapper project to my solution and Visual Studio remaining in a infinite waiting.. Do you know why?
  • WP7.5
    4 Posts | Last post June 19, 2013
    • Can I use it in WP7.1 projects?
    • there is a flavor floating around for wp7 but don't believe it was officially supported.
    • First try to use it in WP8 !!!! Cuz there are not interfaces or classes to use it
    • see this post for WP7
  • How to use?
    3 Posts | Last post June 19, 2013
    • how to use this tool to operation the database?
    • Same question. An example project would be greatly appreciated.
    • see http://www.developer.nokia.com/Community/Wiki/index.php?title=How_to_use_SQLite_in_Windows_Phone&oldid=187499