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
28-Sep-2013Hey Goti!
Just change the query to not select only one record which fits your contition, but all. Then update them all.