title: Run SQL Queries on DataTables, or similar, in .Net, without an RDBMS
body: <p>I'd like to have a dataset or datatables, and be able to run SQL statements on them, without using any external RDBMS. </p>
  
  <p>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):</p>
  
  <pre><code>dim dtJoined as DataTable = MyDataSet.RunSQLQuery ("Select * from People, Orders Where People.PersonID=Orders.OrdereID")
  </code></pre>
  
  <p>Thanks</p>