QueryADataSet (.NET 2.0) 1.0

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:

"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."

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.