You could use LINQ to fetch the records from both the server, then write the similar queries as in sql, LINQ queries to join or modify the data as per...