SQLite is a popular small SQL database that runs on almost all platforms. It has almost become the standard database when building Windows 8 store apps. (Of course, other alternatives exists.) Is has also good support in Windows Phone. Two .NET APIs exist to work with SQLite in .NET, SQLite-NET and SQLiteWinRT.

In this dev.cast I talk with Andy Wigley about SQLite. He has done a very good session at TechEd Europe 2013 called Support Your Demanding LOB Apps With SQLite and Windows Phone 8, that I recommend.

Links

SQLite-WinRT: Database programming on Windows Phone and Windows 8 (Andy Wigley)
http://bit.ly/123duhy

Windows (RT and Phone) and SQLite (Series by Nick Randolph MVP)
http://bit.ly/199xYbr

Sync Framework With SQLite for Windows Store Apps (WinRT) and Windows Phone 8 (Sébastien Pertus)
http://bit.ly/19fToRR

Windows Azure Mobile Services with SQLite Data Sync for Windows RT and Windows Phone Using Portable Class Libraries (Nick Randolph MVP)
http://bit.ly/1bo7wrc

A New SQLite Wrapper for Windows Phone 8 and Windows RT (Matteo Pagani MVP)
http://bit.ly/18TOagR

Posts on SQLite-NET:

Windows Phone Developer Blog: using the SQLite database engine with Windows Phone 8 apps
http://bit.ly/Zxg2Ox

Tim Heuer: HOWTO: SQLite with Windows 8 apps
http://bit.ly/MuzL1e

ErikEJ: Getting Started with SQLite in Windows Store / WinRT apps
http://bit.ly/130PpGa