/// <summary> /// Executes query that does return something (e.g. SELECT). /// </summary> /// <param name="query"></param> /// <returns></returns> public DataTable ExecuteQuery( String query ) { // compiled query SQLiteVdbe statement = new SQLiteVdbe( this, query ); // table for result of query DataTable table = new DataTable(); // create new instance of DataTable with name "resultTable" table = new DataTable( "resultTable" ); // reads rows do { } while ( ReadNextRow( statement.VirtualMachine(), table ) == Sqlite3.SQLITE_ROW ); // finalize executing this query statement.Close(); // returns table return table; }