update multiple records in database using EF core

Question

I'm new to EF i want to execute this sql command using only EF and linq :

I looked on internet but most of the questions are related to old versions of EF

Update Foo set foo.Name ="Modified"
where Foo.id = 6

Is this possible ?

Dharman · Accepted Answer · 2021-05-05 06:12:21Z

1

This is as simple as following:

var foos = Foo.Where(f => f.id == 6).ToList();
foos.ForEach(f => f.Name = "Modified");

context.SaveChanges();

Dharman♦

34k27 gold badges106 silver badges157 bronze badges

answered May 5, 2021 at 6:06

Majid Shahabfar

4,9672 gold badges32 silver badges39 bronze badges

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

2 Comments

is this the only way to do it ? cant we do something to avoid hitting the database multiple times ( read + updates )

Here you hit the database once for a query and once for save data. This is the proper approach.