public static void EnsurePopulated(IApplicationBuilder application) { BookDbContext context = application.ApplicationServices.CreateScope().ServiceProvider.GetRequiredService <BookDbContext>(); if (context.Database.GetPendingMigrations().Any()) { context.Database.Migrate(); } //ADD DATA INITIALLY TO DATABASE if (!context.Booklists.Any()) { context.Booklists.AddRange( new Booklist { BookTitle = "Les Miserables", AuthorFirst = "Victor", AuthorLast = "Hugo", Publisher = "Signet", ISBN = "978-0451419439", Classification = "Fiction", Category = "Classic", Price = 9.95, PageNum = 1488, }, new Booklist { BookTitle = "Team of Rivals", AuthorFirst = "Doris Kearns", AuthorLast = "Goodwin", Publisher = "Simon & Schuster", ISBN = "978-0743270755", Classification = "Non-Fiction", Category = "Biography", Price = 14.58, PageNum = 944, }, new Booklist { BookTitle = "The Snowball", AuthorFirst = "Alice", AuthorLast = "Schroeder", Publisher = "Bantam", ISBN = "978-0553384611", Classification = "Non-Fiction", Category = "Biography", Price = 21.54, PageNum = 832, }, new Booklist { BookTitle = "American Ulysses", AuthorFirst = "Ronald C.", AuthorLast = "White", Publisher = "Random House", ISBN = "978-0812981254", Classification = "Non-Fiction", Category = "Biography", Price = 11.61, PageNum = 864, }, new Booklist { BookTitle = "Unbroken", AuthorFirst = "Laura", AuthorLast = "Hillenbrand", Publisher = "Random House", ISBN = "978-0812974492", Classification = "Non-Fiction", Category = "Historical", Price = 13.33, PageNum = 528, }, new Booklist { BookTitle = "The Great Train Robbery", AuthorFirst = "Michael", AuthorLast = "Crichton", Publisher = "Vintage", ISBN = "978-0804171281", Classification = "Fiction", Category = "Historical Fiction", Price = 15.95, PageNum = 288, }, new Booklist { BookTitle = "Deep Work", AuthorFirst = "Cal", AuthorLast = "Newport", Publisher = "Grand Central Publishing", ISBN = "978-1455586691", Classification = "Non-Fiction", Category = "Self-Help", Price = 14.99, PageNum = 304, }, new Booklist { BookTitle = "It's Your Ship", AuthorFirst = "Michael", AuthorLast = "Abrashoff", Publisher = "Grand Central Publishing", ISBN = "978-1455523023", Classification = "Non-Fiction", Category = "Self-Help", Price = 21.66, PageNum = 240, }, new Booklist { BookTitle = "The Virgin Way", AuthorFirst = "Richard", AuthorLast = "Branson", Publisher = "Portfolio", ISBN = "978-1591847984", Classification = "Non-Fiction", Category = "Business ", Price = 29.16, PageNum = 400, }, new Booklist { BookTitle = "Sycamore Row", AuthorFirst = "John", AuthorLast = "Grisham", Publisher = "Bantam", ISBN = "978-0553393613", Classification = "Fiction", Category = "Thrillers ", Price = 15.03, PageNum = 642, }, new Booklist { BookTitle = "The Lobster Kings", AuthorFirst = "Alexi", AuthorLast = "Zentner", Publisher = "W.W. Norton & Company", ISBN = "978-0393351071", Classification = "Fiction", Category = "Thrillers", Price = 16.95, PageNum = 352, }, new Booklist { BookTitle = "Into the Wild", AuthorFirst = "Jon", AuthorLast = "Krakauer", Publisher = "Villard", ISBN = "978-0330351690", Classification = "Non-Fiction", Category = "Historical", Price = 13.50, PageNum = 224, }, new Booklist { BookTitle = "Barbarian Days: A Surfing Life", AuthorFirst = "William", AuthorLast = "Finnegan", Publisher = "Little, Brown Book Group", ISBN = "978-1594203473", Classification = "Non-Fiction", Category = "Memoir", Price = 15.19, PageNum = 464, } ); //THIS CAN BE TAKEN OUT AFTER THE DATABASE HAS BEEN SEEDED. context.SaveChanges(); } }