public EFFamazonRepo(FamazonDbContext context)
{
_context = context;
}
//Here's the stuff to populate the database.
public static void EnsurePopulated(IApplicationBuilder application)
{
FamazonDbContext context = application.ApplicationServices.CreateScope().ServiceProvider.GetRequiredService <FamazonDbContext>();
if (context.Database.GetPendingMigrations().Any())
{
context.Database.Migrate();
}
if (!context.books.Any())
{
context.books.AddRange(
// All of the books from the spec that are seeded to the database.
new Book
{
title = "Les Miserables",
author = "Victor Hugo",
publisher = "Signet",
isbn = "978-0451419439",
category = "Fiction, Classic",
price = 9.95
},
new Book
{
title = "Team of Rivals",
author = "Doris Kearns Goodwin",
publisher = "Simon & Schuster",
isbn = "978-0743270755",
category = "Non-Fiction, Biography",
price = 14.58
},
new Book
{
title = "The Snowball",
author = "Alice Schroeder",
publisher = "Bantam",
isbn = "978-0553384611",
category = "Non-Fiction, Biography",
price = 21.54
},
new Book
{
title = "American Ulysses",
author = "Ronald C. White",
publisher = "Random House",
isbn = "978-0812981254",
category = "Non-Fiction, Biography",
price = 11.61
},
new Book
{
title = "Unbroken",
author = "Laura Hillenbrand",
publisher = "Random House",
isbn = "978-0812974492",
category = "Non-Fiction, Historical",
price = 13.33
},
new Book
{
title = "The Great Train Robbery",
author = "Michael Crichton",
publisher = "Vintage",
isbn = "978-0804171281",
category = "Fiction, Historical Fiction",
price = 15.95
},
new Book
{
title = "Deep Work",
author = "Cal Newport",
publisher = "Grand Central Publishing",
isbn = "978-1455586691",
category = "Non-Fiction, Self-Help",
price = 14.99
},
new Book
{
title = "It's Your Ship",
author = "Michael Abrashoff",
publisher = "Grand Central Publishing",
isbn = "978-1455523023",
category = "Non-Fiction, Self-Help",
price = 21.66
},
new Book
{
title = "The Virgin Way",
author = "Richard Branson",
publisher = "Portfolio",
isbn = "978-1591847984",
category = "Non-Fiction, Business",
price = 29.16
},
new Book
{
title = "Sycamore Row",
author = "John Grisham",
publisher = "Bantam",
isbn = "978-0553393613",
category = "Fiction, Thrillers",
price = 15.03
}
);
context.SaveChanges();
}
}
