Update problems in Entity Framework

Anonymous User 3309 28 Sep 2013

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?

Ask by Anonymous User

Updated 28 Sep 2013

1 Answers

Anonymous User 28 Sep 2013

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();

        }

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md

forum

Update problems in Entity Framework

Can you answer this question?

1 Answers