static void Main() { var context = new SoftUniEntities(); #region MethodOne var firstEmployee = new Employee() { EmployeeID = 1, FirstName = "Dominik", LastName = "Stoyanov", JobTitle = "Sales Representative", DepartmentID = 6, ManagerID = 268, HireDate = new DateTime(2003, 12, 6), Salary = 2000, AddressID = 200 }; Add(firstEmployee); var methodOneEmployees = context.Employees.Where(e => e.FirstName == "Dominik").Select(e => e); methodOneEmployees.ToList().ForEach(e => Console.WriteLine(e.FirstName)); Console.WriteLine(); #endregion #region MethodTwo Console.WriteLine(FindByKey(12).FirstName); Console.WriteLine(); #endregion #region MethodTree var thirdEmployee = new Employee() { EmployeeID = 1, FirstName = "Dominik", LastName = "Stoyanov", JobTitle = "Sales Representative", DepartmentID = 6, ManagerID = 268, HireDate = new DateTime(2003, 12, 6), Salary = 2000, AddressID = 200 }; Modify(thirdEmployee); var methodThreeEmployees = context.Employees.Where(e => e.EmployeeID == 1).Select(e => e).ToList(); methodThreeEmployees.ForEach(e => Console.WriteLine(e.FirstName)); Console.WriteLine(); #endregion #region MethodFour var fourthEmployee = new Employee() { EmployeeID = 1, FirstName = "Kevin", LastName = "Brown", JobTitle = "Marketing Assistant", DepartmentID = 4, ManagerID = 6, HireDate = new DateTime(1999 - 02 - 26), Salary = 13500, AddressID = 102 }; Delete(fourthEmployee); var methodFourEmployees = _context.Employees.Select(e => e.EmployeeID).ToList(); methodFourEmployees.ForEach(e => Console.WriteLine(e)); #endregion }
private static void Main() { var context = new SoftUniEntities(); }