Update db record in foreach loop with Entity Framework in asp.net mvc 6

Question

I know there are similar questions, but in my case something is wrong. Just trying to update each row, but it does nothing for some reason and no errors.

Thanks.

public ActionResult Index()
{
    using (var db = new DoskaUsContext())
    {
        foreach (var category in db.Categories)
        {
            category.Count = 25;
            db.Categories.Attach(category);
            db.Entry(category).State = EntityState.Modified;
        }

        db.SaveChanges();

        return View();               
    }
}

The "attach" and "state" lines are not needed because the entity is already attach in this example. — Kinetic
– Kinetic, Commented Jul 6, 2016 at 22:59
Are you able to run SQL Profiler to see if/what is hitting the database? — Crowcoder
– Crowcoder, Commented Jul 6, 2016 at 23:51
Sorry, it was my stupid mistake, I forgot to update entity model. Everything works with the code below. — Igor Levashov
– Igor Levashov, Commented Jul 7, 2016 at 0:00

Saket Choubey · Accepted Answer · 2016-07-06 23:14:44Z

1

//3. Mark entity as modified
db.Entry(Category).State = System.Data.Entity.EntityState.Modified;     

//4. out side for loop call SaveChanges
db.SaveChanges();

It works.

answered Jul 6, 2016 at 23:14

Saket Choubey

9166 silver badges11 bronze badges

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

Comments

Gerry · Accepted Answer · 2016-07-06 23:04:15Z

1

You can try the following, I haven´t tested it yet:

public ActionResult Index(Categories category)
    {

        using (var db = new DoskaUsContext())
        {
            foreach (var cat in category)
            {
                category.Count = 25;
                db.Entry(category).State = EntityState.Modified;
            }

            db.SaveChanges();
            return View();               
        }
    }

answered Jul 6, 2016 at 23:04

Gerry

2452 gold badges4 silver badges17 bronze badges

Collectives™ on Stack Overflow

Update db record in foreach loop with Entity Framework in asp.net mvc 6

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related