Link to home
Start Free TrialLog in
Avatar of B_Pati
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.
ASKER CERTIFIED SOLUTION
Avatar of Ess Kay
Ess Kay
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi B_Pati;

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.