Skip to content

A C++/CX wrapper for SQLite functions that sqlite-net depends on. Can be used as an alternative to csharp-sqlite on Windows Phone 8. This library is released under the MIT license.

License

Notifications You must be signed in to change notification settings

litl/sqlite-net-wp8

 
 

Repository files navigation

Call for contributors

I no longer have a Windows Phone device or the time to properly maintain this project. Therefore, I'm asking for someone to take over this project as either the official fork or I can add that person as a contributor to this repository. Please contact me at <mygithubusername>@gmail.com. Thanks!

sqlite-net-wp8

A C++/CX wrapper for SQLite functions that sqlite-net depends on.

This library can be used to directly call into sqlite3.dll on Windows Phone 8 from sqlite-net.

Requirements

Using sqlite-net-wp8

  • Install the sqlite-net-wp8 nuget package into your WP8 project:
    • Select Project -> Manage NuGet Packages...
    • Select Online -> nuget.org
    • Search for sqlite-net-wp8 and install the package.
  • Add a reference to the "SQLite for Windows Phone" extension.
    • Select Project -> Add Reference...
    • Select Windows Phone -> Extensions
    • Check "SQLite for Windows Phone" and click OK
  • Copy the sqlite-net source files (src/SQLite.cs and src/SQLiteAsync.cs) into your WP8 project.
  • Add "USE_WP8_NATIVE_SQLITE" as a conditional build symbol to your project containing the sqlite-net source files (without this, SQLite will use csharp-sqlite):
    • Project -> Properties
    • Click on the Build tab.
    • In the "Configuration" dropdown, select "All configurations".
    • In the "Platform" dropdown, select "All platforms".
    • Append ";USE_WP8_NATIVE_SQLITE" to the "Conditional compilation symbols" textbox.
  • Use sqlite-net as you normally would.

Setting the SQLite Temporary Directory

If you are executing SQLite commands that require the temporary directory to be set, call Sqlite3.set_temp_directory before opening your database with sqlite-net:

Sqlite3.set_temp_directory(Windows.Storage.ApplicationData.Current.LocalFolder.Path);

I will open a pull request to sqlite-net to automatically do this when opening a database, but for now you can call this method directly.

About

A C++/CX wrapper for SQLite functions that sqlite-net depends on. Can be used as an alternative to csharp-sqlite on Windows Phone 8. This library is released under the MIT license.

Resources

License

Stars

Watchers

Forks

Packages

No packages published

Languages

  • C++ 72.7%
  • C 27.3%