Breaking News: Grepper is joining You.com. Read the official announcement!

dotnet linq query to update column value

Nice Narwhal answered on April 1, 2024 Popularity 3/10 Helpfulness 3/10

answer dotnet linq query to update column value

dotnet linq query to update column value

Comment

foreach(var n in animalbirdAdoptionDetails)
{
    // remove unwanted variables and casting expression.
    // if not required then.
    int animalBirdsId = n.AnimalsAndBirdsId;
    int NoAnimal =  Convert.ToInt32(n.NoAnimalsAdopted);
    n.isActive = false;

    // Retrieve existing record
    var entity = context.NameOfAnimalsAndBirds.FirstOrDefault(x => x.Id == n.Id);

    // assign new value to existing property.
    entity.quantity = entity.quantity + moreQuantity;

    // in last just apply save changes.
    context.SaveChanges();
}

Popularity 3/10 Helpfulness 3/10 Language csharp

Source: stackoverflow.com

Tags: c# linq

Link to this answer
Share Copy Link