private static void FindEmployeesByFirstName(SoftuniContext context) { var employees = context .Employees.Where(e => e.Department.Name == "Engineering" || e.Department.Name == "Tool Design" || e.Department.Name == "Marketing" || e.Department.Name == "Information Services").ToList(); foreach (var employee in employees) { employee.Salary *= 1.12m; } context.SaveChanges(); foreach (var employee in employees) { Console.WriteLine($"{employee.FirstName} {employee.LastName} (${employee.Salary})"); } }
private static void AddingNewAddressAndUpdatingEmployee(SoftuniContext context) { var address = new Address() { AddressText = "Vitoshka 15", TownID = 4 }; var nakov = context.Employees.Where(e => e.LastName == "Nakov").FirstOrDefault(); nakov.Address = address; context.SaveChanges(); var addresses = context.Employees .OrderByDescending(e => e.AddressID) .Select(e => e.Address.AddressText) .Take(10); foreach (var a in addresses) { Console.WriteLine(a); } }