QueryADataset allows .NET developers to issue SQL commands against data in one or more ADO.NET Datasets.
QueryADataSet can be used for offline applications that still need the power of a database query-engine for ad-hoc data retrieval requests. Its an excellent addition to the existing ADO.NET framework.
QueryADataSet can be used in back-end web servers for querying cached DataSets for presentation and eliminate expensive round trips to back-end databases.
It is designed to eliminate hundreds of lines of ADO.NET code, with simple, easy to read, SQL statements. QueryADataset is a tool that allows developers to more easily interact with a Dataset.
QueryADataSet is the only assembly available that can be used for querying an XML document using SQL syntax. It sure beats having to learn XQuery syntax. Its great for querying data stored in an RSS feed.
QueryADataSet allows you to implement your own custom scalar and aggregate functions for use in a SQL statement.
Using the QueryADataSet assembly is easy:
Use the Execute method to issue a SELECT statement and return the result as a DataView.
Use the ExecuteNonQuery method to issue a SQL command and return the number of rows affected.
Here's a simple C# example:
DataSet ds = new DataSet();
//populate from commercial database or read offline XML file
string sql = "SELECT TRIM(name), COUNT(name) As 'Total' FROM table1 GROUP BY name ORDER BY 1";
DataView dv = QueryADataSet.DsCommand.Execute(sql, ds);
GridView1.DataSource = dv;
GridView1.DataBind();
Native assembly for .NET 2.0, 3.5 and 4.0 versions.
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 170 companies are using QueryADataset in a wide range of scenarios including web-caching, stock exchange, engine telemetry monitoring, ETL, web-commerce, e-learning and various soft, real-time applications.