?
SolvedPrivate

Linq Query

Posted on 2013-10-27
2
Medium Priority
?
51 Views
Last Modified: 2016-02-10
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
Comment
Question by:B_Pati
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 15

Accepted Solution

by:
Ess Kay earned 1500 total points
ID: 39604750
You can create a stored procedure,  and run it once
0
 
LVL 63

Expert Comment

by:Fernando Soto
ID: 39605943
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question