I've heard that you can use linked servers, however is there another approach using C#? For example, I have a table of 3000+ machines in table A with each having a serial number, location, name, and several more identifiers. However, on table B, I have a smaller version of the same table with fewer machines but each machine still has the same serial number and name. If I wanted to add the location from table A and match them with the serial number of the machine in table B, how would I do so? (Without the use of linked servers).
What I have tried:
Basic C# commands, however I'm still confused as to how I would go about joining the two tables.