SQLite for Windows Phone

Free

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

(7) Review
Visual Studio
2012
Download (33,560)
4/3/2014
3.8.4.3
View
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Description
Reviews (7)
Q and A (8)
Sign in to write a review
Sort by:

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


  • 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\3.8.4.1
      
      * 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" ?>
      <FileList
          DisplayName="SQLite for Windows Phone"
          ProductFamilyName="SQLite.WP80"
          MoreInfo="http://www.sqlite.org/"
          MinVSVersion="12.0"
          SupportsMultipleVersions="Error"
          SupportedArchitectures="x86;ARM">
          <File Reference="sqlite3.dll"/>
      </FileList>
      
      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:
      
      https://github.com/peterhuene/sqlite-net-wp8
      
      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.
  • Support for Visual Studio 2013
    4 Posts | Last post March 11, 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..  
  • vacuum supported?
    1 Posts | Last post February 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;");
                            
      ex:
      "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()"
      
      
      thanks!
  • 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?
      
      thanks,
  • 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
      http://www.codeguru.com/csharp/.net/wp7/using-sqlite-in-your-windows-phone-application.htm
  • 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