Run SQL Queries on DataTables, or similar, in .Net, without an RDBMS

Question

I'd like to have a dataset or datatables, and be able to run SQL statements on them, without using any external RDBMS.

For Example, to take take 2 datatables in a dataset and just join them outright with a SQL statement and Where clause, the result being a new datatable? For example if I have 2 datatables, named People and Addresses in a dataset (that I built using code, not getting from a database .. pardon the old fashioned Join syntax):

dim dtJoined as DataTable = MyDataSet.RunSQLQuery ("Select * from People, Orders Where People.PersonID=Orders.OrdereID")

Thanks

Answer 1

It is not sql, but if you want to query datasets and datatables your best bet is to use LINQ to DataSet

Answer 2

You're not going to be able to run SQL against it, because it isn't an RDBMS, but you can probably get what you want to accomplish using standard LINQ.