Efcore: Add Update Method to DbSet

[mohamedmahmoudalemam]

Why not add Update method to DbSet class
Method Signature: DbSet.Update(Func predicate, T);
So to update a row in a table:
Employee employee = new Employee{FirstName = "Mohamed"};
context.Employees.Update(x => x.Id == 1, employee);
this line should produce this sql statement: update Employee set FirstName = 'Mohamed' where Id = 1;
If for example, user want to update multiple rows this method will help him/her.
example: context.Employees.Update(x => 1 == 1, new Employee{DepartmentId= 1});
this line should produce this sql statement: update Employee set DepartmentId = 1 where 1 =1;

[kmolerov]

EF core should have more functionalities for C/U/D operations without using change tracker - directly composing and execution the query. Most of the times we don't need the change-tracker. It only adds overhead.

[mohamedmahmoudalemam]

Many developers use AsNoTracking method and as you said most of the times we don't need change tracker, so these types of C/U/D operations should be implemented

[ajcvickers]

Duplicate of #795