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.