Can anyone please help on the below scenario with Linq query.
I am having master datatable which is having more than 20000 rows, with multiple columns.
i am having second datatable with distinct City names from city column of master Datatable and then i will generate ID for that and add another column as ID.
once i get that distinct city name and id[second datatable]
i should update all the rows which matches with the city in master datatable from the second table city column with ID in the second datatable…
City column- Bangalore will be there for 2000 rows, i should update in all the 2000 rows of the cityID column in the master table with the id which is there for Bangalore in second datatable.
Thanks in Advance.