Persistent relational data cache
In the examples in the previous section, we didn't use a relational data store for local data. In most cases, especially if we are dealing with a NoSQL database, the relational data paradigm loses its appeal and data denormalization replaces the data consistency concerns in favor of performance. Nevertheless, in certain scenarios, in order to find the optimal compromise between the two, we might need to resort to relational data mappings. In this section, we will take a look at SQLite and how we can use it to have a locally available relational data store on mobile applications. We will implement data caching with SQLite.NET as well as Entity Framework Core.
In the relational data management world, the most popular data management system for mobile applications is without a doubt SQLite. SQLite is, at its core, a relational database management system contained in a C programming library. What differentiates SQLite from other relational data...
