I have a situation where we need to pull data from multiple data sources into one dataset.
Once we have the data in one dataset we would like to somehow manage to execute some sort of [complex] select query on the data in order to generate a new DataTable object with the linked values.
This is tricky because the linking is not always the same, and the column Field Names might also differ.
Now assume [DataTable1] resides in a Microsoft SQL Server database, while [DataTable2] resides in an access database.
-> I cannot import the data into MS SQL solely because it has to be used from the various data sources.
I am able to select all the values from [DataTable1] & [DataTable2] respectively - and add them to a dataset.
Since they are now in the dataset, what can I do to select a linked set of rows into a third datatable?
EG [DataTable1.PersonId] = [DataTable2.pID]
Any help would be greatly appreciated.
LINQ does not seem to fullfill my needs since I might end up having roughly 12 tables which needs linking.