ASP.NET Core 2 Fundamentals

Updating the Record

Let us try to update the salary of an inserted employee record using Entity Framework:

Go to https://goo.gl/4k5J6a to access the code.

static void UpdateSalary(){  using (var db = new EmployeeDbContext())  {    Employee employee = db.Employees.Where(emp    => emp.EmployeeId == 1).FirstOrDefault();    if (employee != null)    {      employee.Salary = 6500;      int recordsUpdated = db.SaveChanges();      Console.WriteLine("Records updated:" +recordsUpdated);      Console.ReadLine();    }  }}

In the preceding method, we find the employee with EmployeeId = 1. Then, we update the salary of the employee to 6500 and save the employee object to the database. Please note that, in the preceding method, we interact with the database a couple of times—once to find the ...