Query update multiple rows

Question

I have table with token, userName, StatusId. Before i insert any row in table for a specific user i would like to check if any rows with active status are there if so update it to inactive.

I am unable to figure out how can i do this in LINQ. Currently iam retreving my values as the query below.

var activeUsers = 
   (from _users in currentDataContext.Users 
        where _users.StatusId.Equals(1) 
        select _session);

Jahan Zinedine · Accepted Answer · 2012-11-30 19:46:10Z

2

users = currentDataContext.Users.Where(o => o.StatusId == 1);
foreach(var item in users)
  item.StatusId = 0;
currentDataContext.SaveChanges();

Beware that If you app is multi user then there is a chance that DB has been changed after you queried the database.

answered Nov 30, 2012 at 19:46

Jahan Zinedine

14.9k5 gold badges49 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user1663996 Over a year ago

Thanks for the response. The status id value is in a look up table with name StatusType with columns statusid and statusdesc. How can i link this in the query directly. For instance where user.statusid=statustype.statusid.

Peter Majeed · Accepted Answer · 2012-11-30 19:02:52Z

0

Would this work?

currentDataContext.Users.Where(x=> x.StatusId == true).First().StatusId = False;
currentDataContext.SaveChanges();

edited Nov 30, 2012 at 19:02

Peter Majeed

5,3922 gold badges35 silver badges58 bronze badges

answered Nov 30, 2012 at 19:01

Jerry

6,5978 gold badges40 silver badges54 bronze badges

1 Comment

Kieren Johnstone Over a year ago

Note, will throw an exception if there's no matching record with StatusId==true

Collectives™ on Stack Overflow

Query update multiple rows

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related