Execute full SQL queries on any DataSet and return the results to your application as a DataView. The QueryADataSet assembly lets you perform complex SQL SELECT statements including DISTINCT UNION, JOINS, GROUP BY, HAVING, ORDER BY, sub-queries, aggregates, PIVOT/UNPIVOT, CAST, CASE against the tables in a dataset.
It also supports CREATE TABLE, CREATE INDEX, INSERT, UPDATE, DELETE, TRUNCATE, CREATE DATABASE, and SAVE commands to manipulating the dataset.
Usage Scenarios include:back-end web servers for querying cached DataSets for presentation. offline applications that still need the power of a database query-engine for ad-hoc data retrieval requests.
querying an XML document loaded into a DataSet using SQL syntax. As one beta tester put it:quot;Microsoft should buy your assembly and make it part of the next.
NET release. :) Having in memory data tables that you could combine with SQL syntax is very flexible and powerful. quot;Over 50 companies are using QueryADataset in a wide range of scenarios including web-caching, stock exchange, engine telemetry monitoring, ETL, web-commerce and various soft, real-time applications.
