QueryADataSet (.NET 2.0)

QueryADataSet (.NET 2.0) 1.0

Execute full SQL queries on any DataSet and return the results...

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.

QueryADataSet (.NET 2.0)

Download

QueryADataSet (.NET 2.0) 1.0