Multiple Tables Android SQLite Tutorial

this is not a question, but a answer of that. I've been facing the problem of finding a good tutorial for SQLite on Android and decide to share it. Here is the link.

For the people who are using C# for building Android app and are not familiar with java:

Java's super("smt") class in C# is ClassName():base("smt")

final in C# is readonly

//Java code
ClassName.class.getSimpleName();
//C# code
nameof(ClassName);

Synchronized methods in C# are declared like

[MethodImpl(MethodImplOptions.Synchronized)]
public void MethodName()
{
   //code here
}

For using the Cursor I recommend to make a new using instance like:

using Cursor = Android.Database.ICursor;

And then the code is same like the example.