Example #1
0
 private static void InitializeDatabase()
 {
     using (EmployeesDBContext db = new EmployeesDBContext())
     {
         db.Database.Initialize(true);
     }
 }
Example #2
0
 private static void SeedDatabase(IEnumerable <Employee> employees)
 {
     using (EmployeesDBContext db = new EmployeesDBContext())
     {
         db.Employees.AddRange(employees);
         db.SaveChanges();
     }
 }
Example #3
0
        static void Main(string[] args)
        {
            ConfigureAutomapping();
            //InitializeDatabase();
            //IEnumerable<Employee> employees = CreateEmployees();
            //SeedDatabase(employees);

            using (EmployeesDBContext db = new EmployeesDBContext())
            {
                var employeesDto = db.Employees
                                   .Where(e => e.Birthdate.Value.Year < 1990)
                                   .ProjectTo <EmployeeDto>()
                                   .ToList();

                foreach (var e in employeesDto)
                {
                    Console.WriteLine(e.ToString());
                }
            }
        }