public static void EnsurePopulated(IApplicationBuilder application) { BookDBContext context = application.ApplicationServices. CreateScope().ServiceProvider.GetRequiredService <BookDBContext>(); //Checking for any migrations if (context.Database.GetPendingMigrations().Any()) { //Migrating info context.Database.Migrate(); } //if there isn't data already in the database, it will add this seed data below if (!context.Books.Any()) { context.Books.AddRange( new Book { Title = "Unbroken", AuthorFirst = "Laura", AuthorLast = "Hillenbrand", Publisher = "Random House", ISBN = 9780812974492, Classification = "Non-Fiction", Category = "Historical", Price = 13.33, PageNum = 528 }, new Book { Title = "Deep Work", AuthorFirst = "Cal", AuthorLast = "Newport", Publisher = "Grand Central Publishing", ISBN = 9781455586691, Classification = "Non-Fiction", Category = "Self-Help", Price = 14.99, PageNum = 304 }, new Book { Title = "Sycamore Row", AuthorFirst = "John", AuthorLast = "Grisham", Publisher = "Bantam", ISBN = 9780553393613, Classification = "Fiction", Category = "Thrillers", Price = 15.03, PageNum = 642 }, new Book { Title = "The Snowball", AuthorFirst = "Alice", AuthorLast = "Schroeder", Publisher = "Bantam", ISBN = 9780553384611, Classification = "Non-Fiction", Category = "Biography", Price = 21.54, PageNum = 832 }, new Book { Title = "Cinder", AuthorFirst = "Marissa", AuthorLast = "Meyer", Publisher = "Square Fish", ISBN = 9781250768889, Classification = "Fiction", Category = "Fantasy", Price = 9.89, PageNum = 448 }, new Book { Title = "Howl's Moving Castle", AuthorFirst = "Diana", AuthorMid = "Wynne", AuthorLast = "Jones", Publisher = "Greenwillow Books", ISBN = 9780064410342, Classification = "Fiction", Category = "Fantasy", Price = 8.99, PageNum = 336 }, new Book { Title = "Prey: The Drovers", AuthorFirst = "John", AuthorLast = "Brown", Publisher = "Blacksword Books", ISBN = 9781940427195, Classification = "Fiction", Category = "Fantasy", Price = 12.99, PageNum = 254 } ); //saves changes context.SaveChanges(); } }
//Constructor public EFBookRepository(BookDBContext context) { _context = context; }