Local Data Access III: SQLite
In the last two chapters we looked at how to read and write data locally using the Jet API, application storage, and IndexedDB. In this chapter, we discuss yet another local storage option for Windows 8 apps, SQLite. This chapter starts with an introduction to SQLite, and then we will look into various setup procedures needed to include SQLite in a project. We also learn to use sqlite-net, a SQLite wrapper. As always, we end this chapter by developing a Windows 8 app using SQLite as the data storage option. We use MVVM Light as our MVVM framework for this Bill Reminder app, and by doing so we learn to integrate and use MVVM Light, one of the most popular MVVM frameworks, in the project.