Here is a sample scenario:
a. The program has the option to get data from Oracle (table1), Access (table2) or flatfiles (CSV/XML)(table3).
b. The results are stored in a single dataset.
c. Relate the tables, just like querying them from a single database, like so,
SELECT * FROM table1, table2, table3
WHERE table1.col1 = table2.col1
AND table1.col1 = table3.col1
AND table1.col2 = 'Test'
I know this is easy on a single database, but if data can come from multiple sources, what is the best solution? Aside from getting all the data and making a temporary table for each in a single database and running the above sql against it?
I know that datasets does not permit 'select' statements. Will .relationships and .filters somehow do the job(?).
Thanks very much,