Update multiple rows at once with different values

Imar · March 1st, 2012, 01:42 PM

Quote:

if I am not wrong then won't it hit database multiple times?

Yes, but in the end you need to do that anyway as you can't update multiple, unrelated rows. The suggestion from irProject with a WHERE clause is the only way really.

EF lets you update multiple rows. You query the objects you want to change, set properties on them and then update the changes.

Try a Google search for asp.net update multiple rows. You'll find lots of useful examples.

Cheers,

Imar

sophia · March 1st, 2012, 02:37 PM

Ok I will use Stored procedures.

Quote:

EF lets you update multiple rows

curious, please give a code snippet how it updates multiple rows.

Many thanks both of you

Imar · March 1st, 2012, 02:45 PM

EF does batch uodate by design. So it automatically saves changes to all objects in the context that have been changed. E.g.:

Code:

 
var article1 = context.Articles.Where (a => a.Id == 1).FirstOrDefault();
article1.SomeProperty = "SomeValue";
var article2 = context.Articles.Where (a => a.Id == 1).FirstOrDefault();
article2.SomeProperty = "SomeValue";
context.SaveChanges();

would save both articles.

Cheers,

Imar

sophia · March 2nd, 2012, 12:40 PM

Thanks Imar,
it is working, and sooner I will use stored procesures

Thanks once again