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();
}