private static void InitializeDatabase() { using (EmployeeCotext context = new EmployeeCotext()) { context.Database.Initialize(true); } }
private static void SeedDatabase(IEnumerable <Employee> employees) { using (EmployeeCotext context = new EmployeeCotext()) { context.Employees.AddRange(employees); context.SaveChanges(); } }
static void Main(string[] args) { //01.Simple Mapping ConfigureAutomapping(); //Employee emp = new Employee() //{ // FirstName = "Pesho", // LastName = "Petrov", // Salary = 100m, // Birthday = DateTime.Now, // Address = "Tintiava 15" //}; //EmployeeDTO dto = Mapper.Map<EmployeeDTO>(emp); //Console.WriteLine($"{dto.FirstName} - {dto.LastName} - {dto.Salary}"); //Uncomment for 2 exercise //IEnumerable<Employee> managers = CreateManagers(); //IEnumerable<ManagerDTO> managerDtos = Mapper.Map<IEnumerable<Employee>, // IEnumerable<ManagerDTO>>(managers); //foreach (var man in managerDtos) //{ // Console.WriteLine(man.ToString()); //} //InitializeDatabase(); //IEnumerable<Employee> employees = CreateManagers(); //SeedDatabase(employees); using (var context = new EmployeeCotext()) { var employees = context.Employees .Where(e => e.Birthday.Value.Year > 1990) .OrderByDescending(e => e.Salary) .ProjectTo <EmployeeDTO1>(); foreach (var emp in employees) { Console.WriteLine(emp.ToString()); } } }