Update Multiple columns of multiple rows using LINQ

Question

I am using Entity framework for building an app.

Table to be updated.

[Id] [CheckItemId]  [Checked]  [Comment]
1      100             1          abc
2      150             0          xyz

Class:

public class CheckListRequest
{
    public int ID { get; set; }
    public bool IsChecked { get; set; }
    public string Comment { get; set; }
}

public static void UpdateCheckList(List<CheckListRequest> checkList){

}

How do I update the table multiple column like (Checked,comment) with the values coming in list from frontend using LINQ?

ekad · Accepted Answer · 2014-11-11 14:47:15Z

6

Assuming dbContext is your DataContext and Id is the primary key of the table, try this:

public static void UpdateCheckList(List<CheckListRequest> checkList)
{
    foreach (CheckListRequest clr in checkList)
    {
        CheckListRequest clrInDB = dbContext.CheckListRequests.SingleOrDefault(o.Id == clr.Id);
        clrInDB.IsChecked = clr.IsChecked;
        clrInDB.Comment = clr.Comment;
    }

    dbContext.SaveChanges();
}

edited Nov 11, 2014 at 14:47

answered Jan 20, 2014 at 7:09

ekad

14.7k26 gold badges46 silver badges49 bronze badges

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

5 Comments

ankur Over a year ago

do the savechanges neeed to come inside the loop to make the changes every time the loop runs...

ekad Over a year ago

That depends on your requirements, let's say you update 10 records and the 4th record fails, do you want to rollback the change of the first three records?

Moeri Over a year ago

You can reduce that .Where(..).SingleOrDefault() to a single SingleOrDefault(...) call by the way ;-)

ankur Over a year ago

no rollback is needed even if some record fails it will be logged by other methods.

ekad Over a year ago

@ankur in that case you can put dbContext.SaveChanges() inside the foreach loop

MarcinJuraszek · Accepted Answer · 2014-01-20 07:10:40Z

0

How do I update the table multiple column like (Checked,comment) with the values

Exactly the same way you'd update only one column...

Get the entity from context
Update column/columns
Call SaveChanges() method on context.

using(var ctx = new MyContext())
{
    var entity = ctx.Table.First(t => t.Id == myId);
    entity.Prop1 = "newValue";
    entity.Prop2 = 23;

    ctx.SaveChanges();
}

answered Jan 20, 2014 at 7:10

MarcinJuraszek

126k15 gold badges200 silver badges267 bronze badges

1 Comment

ankur Over a year ago

there are multiple ids coming , what i meant is there are at least 10 object in the List<CheckListRequest> checkList) ,each object corresponds to a row in database so how do i update multiple columns of the table rows by taking values from the list

Girish Vadhel · Accepted Answer · 2014-01-20 07:23:45Z

0

You can use foreach loop on your list as below:

public static void UpdateCheckList(List<CheckListRequest> checkList)
{
    checkList.foreach(CL =>{
              CheckListRequest objCLR= DataContext.CheckListRequests
              .SingleOrDefault(E => E.Id == CL.Id);
        objCLR.IsChecked = CL.IsChecked;
        objCLR.Comment = CL.Comment;
        });

    DataContext.SaveChanges();
}

answered Jan 20, 2014 at 7:23

Girish Vadhel

7451 gold badge5 silver badges17 bronze badges

Comments

Dharmender Tongar · Accepted Answer · 2020-11-26 07:04:57Z

0

You can use ForEachAsync or ForEach like below

var actionTakenOnEndorsement = _context.Endorsement.Where(x => x.IsDeleted == false && x.IsApproved != null).OrderBy(o => o.SolutionId).ThenByDescending(o => o.ModifiedOn).DistinctBy(x => new { x.SolutionId, x.UserId }).AsQueryable();
                
await actionTakenOnEndorsement.ForEachAsync(x => { x.IsEndorsementRevoked = true; x.Comment = "Revoked by system"; });

answered Nov 26, 2020 at 7:04

Dharmender Tongar

464 bronze badges

Collectives™ on Stack Overflow

Update Multiple columns of multiple rows using LINQ

4 Answers 4

5 Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

5 Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related