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) doesn’t have any addons yet. Would you recommend any to us? Tell us
Laws concerning the use of this software vary from country to country. We do not encourage or condone the use of this program if it is in violation of these laws.
We use own and third party cookies to improve our services and your experience. This includes to personalise ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. If you continue browsing, you are considered to have accepted such use. You may change your cookie preferences and obtain more information here.