
SQLite is an excellent choice for local storage within a mobile application. It is lightweight and with virtually zero configuration. Adding SQLite to a Xamarin.Forms project is fairly straightforward:
1. Add the nuget package SQLite-net PCL to each project (PCL, Android, & iOS)
Author = Frank A Krueger
ID = sqlite-net-pcl
2. Add an interface to the PCL project called: ISQLiteService.cs
3. Add a class to the iOS project called: SQLiteService.cs
4. Add a class to the Android project also called SQLiteService.cs
5. Add a class to the PCL project called: BaseItem.cs
6. Add a class to the PCL project called: Database.cs
7. To create a table model, simply create a class with public properties (with getters and setters) of the types and names of each field in the table. The class should inherit from BaseItem; this adds an auto incrementing ID field.
8. Create an instance of Database.cs called: database
To create a table simply call database.CreateTable();
You now have a fully functioning database in Forms. To see a database in action, checkout out my example project on GitHub.
If you have any comments, questions, or suggestions, feel free to leave a comment below.