public static void Main(string[] args)
{
using (var dbContext = new EmployeeDatabaseEntities())
{
logger.Info("Starting looping the departments");
var departmentsList = dbContext.Departments;
foreach (var department in departmentsList)
{
logger.Info($"Operatin on department {department.Name} at location {department.Location}");
var employeesList = department.Employees;
foreach (var employee in employeesList)
{
logger.Info($"Employee : Name = {employee.Name}, Email = {employee.Email}, Salary = {employee.Salary}");
}
}
var itEmployees = dbContext.Employees.AsQueryable().Where(emp => emp.Department.Name.Equals("IT"));
foreach (var emp in itEmployees)
{
logger.Info($"Employee in IT Depratment : {emp.Name}, {emp.Salary}");
}
dbContext.Departments.Add(new Department()
{
Name = "Transport",
Location = "Delhi"
});
}
}
