I have a Dataset that contains two data tables and I now need to merge them based on a "key" column which they both share.

I'm wondering what the best way to do this is. I've researched a few methods (Merge, LINQ) but I'm relatively new to .NET and I'd like to know what the preferred method is.

I have the two data tables all set - just need to join them based on a field - ideally leaving behind all records in data table 1 and only the matches from data table 2.