Modifying properties in object with LINQ and functions Lamba

Question

Friends,

I know how to deploy and retrieve a single element in LINQ, but how can I do to change all the properties in a list. In the line below, I can only modify a record, I would modify several.

_ListaAcaoMenuInfo.Where(p => p.Id_acao == id).FirstOrDefault().Id_menu = 0;

Thanks

Answer 1

Use foreach:

var l = _ListaAcaoMenuInfo.Where(p => p.Id_acao == id).ToList();

foreach (Thing i in l)
{
   i.Id_menu = 0;
   //now use your Context object to save back to the database
}

Answer 2

You wouldn't want to. LINQ is not to be used for side effects. There's a foreach loop for that.

foreach (var x in collection.where(x => x.Foo = "Blah"))
   x.Foo = "Bar";

Answer 3

Use the ForEach function of a List...

_ListaAcaoMenuInfo.Where(p => p.Id_acao == id).ToList().ForEach(item=>item.Id_menu=0);