WP SQLite Query Executor
First of all use only one object of database through out application.means if you create a "var db = new SQLiteConnection(dbPath)" object then use it in whole application.
for insert and delete use :: await database.ExecuteStatementAsync(query);
and for select::
var statement1 = await database.PrepareStatementAsync(""); while (await statement1.StepAsync()) {//statement1.Columns["name"] //your logic }
Try to maintain one common file for query and rendering logic.. It will save time.All the best..!!