Combine Data from multiple DataSets

Question

I'm loading data from multiple xml files with different schemas into DataSets. I do have foreign key style relationships between the tables in each xml file but to date they're only enforced by code. I need to access data coming from multiple files and display it in a DataGridView.

Is there a way to merge the data from multiple files into a single DataSet?

Alternately can I write linq to dataset queries across multiple DataSets?

Answer 1

Perhaps the DataSet.Merge() method will help you out? You can simply load the files as you're currently doing, and merge them together.