UPDATE PROBLEMS IN ENTITY FRAMEWORK

Goti Bandu

Total Post:119

Points:835
Posted by  Goti Bandu
 1350  View(s)
Ratings:
Rate this:

I want update my table with two conditions :

Type == "Employee" && Approved == false

and I use this code :

using (NoavaranModel.NoavaranEntities1 db=new NoavaranModel.NoavaranEntities1())
{
    var query = db.Students.Where(p => p.Type == " Employee" && p.Approved == false).Single();
    query.IsRecivedSMS = true;
    db.SaveChanges();
}

but it's not working. Just updates one recode in db. How can I update all rows with above conditions in Entity Framework?

  1. Pravesh Singh

    Post:101

    Points:709
    Re: Update problems in Entity Framework

    Hey Goti!

    Just change the query to not select only one record which fits your contition, but all. Then update them all.

    using (NoavaranModel.NoavaranEntities1 db=new NoavaranModel.NoavaranEntities1())
            {
                var query = db.Students.Where(p => p.Type == "پیش ثبت نام" && p.Approved == false);
                foreach(var record in query)
                {
                  record.IsRecivedSMS = true;
                }
                db.SaveChanges();
            }

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!