New open source Portable Class Library for SQLite

You want to use SQLite in your Windows Phone, Windows Store and/or .Net 4.5 project, but you are not sure which distribution DLL to use and whether you need to create your own managed wrapper for each of these targets? Don’t search any longer: MS Open Tech has you covered. Here is an open source Portable Class Library for SQLite available as a NuGet Package (and source code) for you.

SQLite is an open source self-contained, server less, zero-configuration, transactional SQL database engine commonly used in mobile applications. On the SQLite.org Website, you can download various binary distributions of the C++ library for .Net, Windows Store and Windows Phone. If you want to use SQLite in managed code you then have to consider writing (or finding some wrapper). Not an easy task, especially considering that such a wrapper would have to be modified for each of the different distributions.

With the Portable Class Library for SQLite, developers can code against one single API, similar to the SQLite C++ one, across Windows Phone, Windows Store and .Net Framework 4.5, without having to worry about what assembly is loaded.

For detailed information on how to use the Portable Class Library for SQLite, check out the documentation on Codeplex.

Feel free to let us know what you think of this wrapper for SQLite by joining the conversation or commenting on this post.


22 thoughts on “New open source Portable Class Library for SQLite

  1. Pingback: New Open Source Portable lass Library for SQLite - Interoperability @ Microsoft - Site Home - MSDN Blogs

    • At this time the library is not exposed as a WinRT component but only as a Portable Class library available as a NuGet package that you install within your C# Windows Store or Windows Phone app, or your .Net 4.5 desktop application project.
      The WinRT component is definitively a good idea and we will consider it for a future update.

  2. Pingback: New Open Source Portable Class Library for SQLite | MSDN Blogs

  3. Pingback: Open source Portable Class Library for SQLite | Around computing

    • At this time SQLite does not ship 64 bits libraries yet. Along with the .NET 4.0 support, this is an interesting feature we might consider for a future update of the library. Thanks for sharing your thoughts

  4. Pingback: Windows App Developer Links – 2014-02-07 | Dan Rigby

  5. Pingback: Portable Class Library for SQLiteを使ってみた | OPC Diary

  6. Pingback: The new Portable Class Library for SQLite | Around and About .NET World

  7. Pingback: The new Portable Class Library for SQLite

  8. Pingback: SQLite en todas partes - Openness@Microsoft - Site Home - TechNet Blogs

  9. Now only if someone bothered to update it and add Windows Phone 8.1 support! How exactly are people supposed to use databases on WP8.1 without any kind of database support?

Leave a Reply