Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 57
  • Last Modified:

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.
0
B_Pati
Asked:
B_Pati
1 Solution
 
Ess KayEntrapenuerCommented:
You can create a stored procedure,  and run it once
0
 
Fernando SotoCommented:
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.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now