I have a scenario where i have two data table dt and dt1. in dt there are two column A and B. In dt1 there are also two column C and D.
My problem is if the any value of column C from dt1 matched with any value of column A of dt then the value of column D for matched row must be come in column B to the corresponding matched rows in dt. if not matched then there should be blank.
For ex. dt have two column
dt1 have two column
expected result for dt is
Please suggest me the LINQ Query for the same because i have lot of records in dt.
Thanks in Advance.