Using the SQLite database

SQLite is a Relational DataBase Management System (RDBMS) that has the benefit of being very small (~655KB) and written in C. These two assets make SQLite very portable and our first choice as programmers wishing to use Object Relational Mapping (ORM) embedded in a phone. Also SQLite respects the Atomicity, Consistency, Isolation, and Durability (ACID) principles, which ensure we have consistent data at any time.

Getting ready

Despite the fact that SQLite is the favorite RDBMS of thousands of programmers when it comes to using a database of fun, the SQLite .NET library isn't part of the standard library that comes with Xamarin. Therefore, we have to add it to our projects. You can add it in two different ways, such as the ...

Get Xamarin Studio for Android Programming: A C# Cookbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.