Query-Based

QueryDataSet holds a collection of tables resulting from database queries.

Following sample snippet creates a dataset containing two tables: FOO, resulting from specified query and BAR, resulting from generated query "SELECT * FROM BAR".

QueryDataSet dataSet = new QueryDataSet(connection);
dataSet.addTable("FOO", "SELECT * FROM TABLE WHERE COL='VALUE'");
dataSet.addTable("BAR");

connection is an IDatabaseConnection. Unlike IDatabaseConnection.createQueryTable() (a single ad hoc table, see Using a Query to Take the Database Snapshot), QueryDataSet accumulates several query-defined tables into one dataset.