While storing data in textual and binary files is a convenient solution, using a database gives you significantly more possibilities. Fortunately, it is really easy to use the SQLite database in UWP applications running on various platforms, such as smartphones and desktops. In the current recipe, you will learn how to create a local SQLite database as well as how to create tables when the application is launched for the first time.
The subject of designing databases as well as using queries to select, insert, update, and delete data from particular tables is of course too big and can't be described in detail in this chapter. For this reason, this book will focus on presenting some practical aspects of using databases, so basic knowledge about databases, tables, and queries is necessary.
As an example prepared in this and the following recipes, you will develop a simple application for creating an offline blog, where you can present, add, edit, and delete...