public static void EnsurePopulated(IApplicationBuilder application) { AppointmentsContext context = application.ApplicationServices. CreateScope().ServiceProvider.GetRequiredService <AppointmentsContext>(); if (context.Database.GetPendingMigrations().Any()) { context.Database.Migrate(); } if (!context.Appointments.Any()) { context.Appointments.AddRange( new Appointment { GroupName = "Smith Group", GroupSize = 4, GroupEmail = "*****@*****.**", ApptTime = new DateTime(2021, 05, 01) }, new Appointment { GroupName = "Johnson Group", GroupSize = 4, GroupEmail = "*****@*****.**", ApptTime = new DateTime(2021, 05, 02), }, new Appointment { GroupName = "Thomas Group", GroupSize = 2, GroupEmail = "*****@*****.**", ApptTime = new DateTime(2021, 05, 03), }, new Appointment { GroupName = "Larry Group", GroupSize = 3, GroupEmail = "*****@*****.**", ApptTime = new DateTime(2021, 05, 04), }, new Appointment { GroupName = "Sally Group", GroupSize = 8, GroupEmail = "*****@*****.**", ApptTime = new DateTime(2021, 05, 05), }, new Appointment { GroupName = "Sam Group", GroupSize = 1, GroupEmail = "*****@*****.**", ApptTime = new DateTime(2021, 05, 06), } ); //save all changes context.SaveChanges(); } }
//constructor public EFAppointmentRepository(AppointmentsContext context) { _context = context; }