/// <summary> /// Creates new instance of SQLiteVdbe class by compiling a statement /// </summary> /// <param name="query"></param> /// <returns>Vdbe</returns> public SQLiteVdbe( SQLiteDatabase db, String query ) { vm = null; // prepare and compile csSQLite.sqlite3_prepare_v2( db.Connection(), query, query.Length, ref vm, 0 ); }
private void InitializeTables(SQLiteDatabase db) { db.ExecuteNonQuery("BEGIN EXCLUSIVE"); for (int i = 0; i < CREATE_Commands.Length; i++) { db.ExecuteNonQuery(CREATE_Commands[i]); } }
private SQLiteDatabase OpenDB(string fileName) { if (File.Exists(fileName)) File.Delete(fileName); var db = new SQLiteDatabase(fileName); for (int i = 0; i < PRAGMA_Commands.Length; i++) { db.ExecuteNonQuery(PRAGMA_Commands[i]); } return db; }