DataSet is supposed to be an in-memory database=2E So is it=
possible to fire a query on it=2E I want to fire a "Select" query=
(with alises in it) and also a "Transform" (Crosstab) query=2E In=
the current scenario I am putting things in an Access table but=
for performance reasons want to deal with in-memory contents=2E

Thanks in advance=2E
--------------------------------
From: Arun Gupta

-----------------------
Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/)

It is a very weak implementation of a database. It is possible to SELECT on a
single DataTable, to filter results. It is not possible to complete queries
over multiple tables using the built in methods of any of the System.Data
objects. You can, potentially, move into XML to accomplish what you desire,
but it is likely to be a) more time consuming, b) less maintainable and c)
worse performing.


---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************



[quoted text, click to view]