B_Pati
asked on
Linq Query
Hi Experts
I have tables with all tables having column status. I need help in writing
a linq query to update the rows of this column to status ='reject' on all tables.
i have around 10 tables
i can write an update query on seperate tables independently . but is there a better way.
Please advice.
I have tables with all tables having column status. I need help in writing
a linq query to update the rows of this column to status ='reject' on all tables.
i have around 10 tables
i can write an update query on seperate tables independently . but is there a better way.
Please advice.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You will have better performance if you do it the way @esskayb2d has suggested. The reason being is that you will have to download all the records from all the 10 tables and then iterate through the collections to modify the column status then save you changes back to the database.