How to use Sqlite for Xamarin.Android -

i new sqlite. understand far.

please confirm understanding. 1) sqlite engine built android-os system

so, dont need download , install sqlite engine website.

now, have these questions :

2) if include sqlite database( data in it) in project, need read ( use memorystream read buffer, based on wp on slqce ) folder or directory under sqlite engine?

3) there tutorial on create table, add, insert, update sqlite, setup relationship

4) referential integrity supported? if delete primary key , foreign key deleted well.

thanks

one application has helped me in building sqlite databases this
sqlite expert, http://www.sqliteexpert.com/ standalone piece of sofware gui can design databases , produce sql code produce database.

the thing setting database need create class android.database.sqlite.sqliteopenhelper object , override oncreate(sqlitedatabase db) , onupgrade(sqlitedatabase db, int oldversion, int newversion) methods. write insert methods , forth.

good luck, james.