private static void InitializeDatabase() { using (EmployeesDBContext db = new EmployeesDBContext()) { db.Database.Initialize(true); } }
private static void SeedDatabase(IEnumerable <Employee> employees) { using (EmployeesDBContext db = new EmployeesDBContext()) { db.Employees.AddRange(employees); db.SaveChanges(); } }
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()); } } }