I have 2 datasets I need to merge them for only the rows that match on a single column between them.
Table 1 Table 2
ID Name ID Name
1 John 1 Bob
2 Jane 3 Fred
Want to merge table 1 with table 2 - only Bob should be added to table 1
What's the best way to do this a loop or can I do via LINQ