Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

Update problems in Entity Framework

Anonymous User 2762 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?

Anonymous User

Other

I am a content writter !

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

        }

advertising