private static void DeleteEmployeeSlow(int empId) { var context = new SoftUniEntities(); var emp = context.Employees.Find(empId); context.Employees.Remove(emp); context.SaveChanges(); }
private static int CreateSampleEmployee() { var emp = new Employee() { FirstName = "First", MiddleName = "M.", LastName = "Last", AddressID = 1, DepartmentID = 1, HireDate = DateTime.Now, JobTitle = "Freelancer", Salary = 25000 }; var context = new SoftUniEntities(); context.Employees.Add(emp); context.SaveChanges(); return emp.EmployeeID; }
private static void DeleteEmployeeFastEFExtended(int empId) { var context = new SoftUniEntities(); context.Employees.Where(e => e.EmployeeID == empId).Delete(); }
private static void DeleteEmployeeFastNativeSQL(int empId) { var context = new SoftUniEntities(); context.Database.ExecuteSqlCommand("DELETE FROM Employees WHERE EmployeeID = {0}", empId); }