In a previous post (LINQ to the rescue!) I used linq to merge multiple DataTables, sort them and exclude duplicates.
But, what about filling those DataTables in the first place. If, like I, you have multiple databases in production at work and need to show to the users a “database agnostic” view of their data, you need to query all those databases and merge the data.
Querying a large number of databases in serial is a slow process, but playing with threads seems … dangerous.
Well, with the new Parallel libraries, this becomes very simple to do, even with Oracle ( ;-) )