Xamarin forms working in offline mode with sqllite

Question

I need a nuget package or some good practice how to do a whole-app offline mode working? Im having login, xf maps, CRUD operations etc. I found some guidence but it is regarding xf offline mode with azure but I really need is logging everything in my db.

Logic: after each api call (while I have internet), drop all tables, create new ones, and insert fresh data. (with delete wont work, because, those unique ids are reserved already) when I dont have internet, read from db "old" data

Answer 1

Using this you can store your data in Local storage and retrieve from that. https://learn.microsoft.com/en-us/learn/modules/store-local-data-with-sqlite/4-exercise-store-data-locally-with-sqlite

Answer 2

There is SQLite package for xamarin, in fact more than one