Пример #1
0
 private static void InitializeDatabase()
 {
     using (EmployeeCotext context = new EmployeeCotext())
     {
         context.Database.Initialize(true);
     }
 }
Пример #2
0
 private static void SeedDatabase(IEnumerable <Employee> employees)
 {
     using (EmployeeCotext context = new EmployeeCotext())
     {
         context.Employees.AddRange(employees);
         context.SaveChanges();
     }
 }
Пример #3
0
        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());
                }
            }
        }