public static void Blah(IApplicationBuilder application)
{
BookDBContext context = application.ApplicationServices.
CreateScope().ServiceProvider.GetRequiredService <BookDBContext>();
if (context.Database.GetPendingMigrations().Any())
{
context.Database.Migrate();
}
if (!context.Books.Any())
{
context.Books.AddRange(
//this is where we input all of our data for the database
new Books
{
BookID = 1,
Title = "Les Miserables",
AuthorFirst = "Victor",
AuthorLast = "Hugo",
Publisher = "Signet",
ISBN = "978 - 0451419439",
Class = "Fiction",
Category = "Classic",
Price = 9.95,
NumPages = 1488
},
new Books
{
BookID = 2,
Title = "Team of Rivals",
AuthorFirst = "Doris",
AuthorMiddle = "Kearns",
AuthorLast = "Goodwin",
Publisher = "Simon & Schuster",
ISBN = "978 - 0743270755",
Class = "Non-Fiction",
Category = "Biography",
Price = 14.58,
NumPages = 944
},
new Books
{
BookID = 3,
Title = "The Snowball",
AuthorFirst = "Alice ",
AuthorLast = "Schroeder",
Publisher = "Bantam",
ISBN = "978 - 0553384611",
Class = "Non-Fiction",
Category = "Biography",
Price = 21.54,
NumPages = 832
},
new Books
{
BookID = 4,
Title = "American Ulysses",
AuthorFirst = "Ronald",
AuthorMiddle = "C.",
AuthorLast = "White",
Publisher = "Random House",
ISBN = "978 - 0812981254",
Class = "Non-Fiction",
Category = "Biography",
Price = 11.61,
NumPages = 846
},
new Books
{
BookID = 5,
Title = "Unbroken",
AuthorFirst = "Laura ",
AuthorLast = "Hillenbrand",
Publisher = "Random House",
ISBN = "978 - 0812974492",
Class = "Non-Fiction",
Category = "Historical",
Price = 13.33,
NumPages = 528
},
new Books
{
BookID = 6,
Title = "The Great Train Robbery",
AuthorFirst = "Michael",
AuthorLast = "Crichton",
Publisher = "Vintage",
ISBN = "978 - 0804171281",
Class = "Fiction",
Category = "Historical Fiction",
Price = 15.95,
NumPages = 288
},
new Books
{
BookID = 7,
Title = "Deep Work",
AuthorFirst = "Cal",
AuthorLast = "Newport",
Publisher = "Grand Central Publishing",
ISBN = "978 - 1455586691",
Class = "Non-Fiction",
Category = "Self - Help",
Price = 14.99,
NumPages = 304
},
new Books
{
BookID = 8,
Title = "It's Your Ship",
AuthorFirst = "Michael ",
AuthorLast = "Abrashoff",
Publisher = "Grand Central Publishing",
ISBN = "978 - 1455523023",
Class = "Non-Fiction",
Category = "Self - Help",
Price = 21.66,
NumPages = 240
},
new Books
{
BookID = 9,
Title = "The Virgin Way",
AuthorFirst = "Richard",
AuthorLast = "Branson",
Publisher = "Portfolio",
ISBN = "978 - 1591847984",
Class = "Non-Fiction",
Category = "Business",
Price = 29.16,
NumPages = 400
},
new Books
{
BookID = 10,
Title = "Sycamore Row",
AuthorFirst = "Row",
AuthorMiddle = "John",
AuthorLast = "Grisham",
Publisher = "Bantam",
ISBN = "978 - 0553393613",
Class = "Fiction",
Category = "Thrillers",
Price = 15.03,
NumPages = 642
},
new Books
{
BookID = 11,
Title = "Range",
AuthorFirst = "David",
AuthorMiddle = "",
AuthorLast = "Epstein",
Publisher = "Macmillan",
ISBN = "978-1509843497",
Class = "Non-Fiction",
Category = "Human Behavior",
Price = 18.53,
NumPages = 339
},
new Books
{
BookID = 12,
Title = "The Boys in the Boat",
AuthorFirst = "Daniel",
AuthorMiddle = "James",
AuthorLast = "Brown",
Publisher = "Penguin Books",
ISBN = "978-0670025817",
Class = "Non-Fiction",
Category = "Historical Narrative",
Price = 20.96,
NumPages = 404
},
new Books
{
BookID = 13,
Title = "The Alchemist",
AuthorFirst = "Paulo",
AuthorMiddle = "",
AuthorLast = "Coelho",
Publisher = "HarperTorch",
ISBN = "006-2502174",
Class = "Fiction",
Category = "Adventure",
Price = 10.13,
NumPages = 163
}
);
context.SaveChanges();
}
}
public EFBookListRepository(BookDBContext context)
{
_context = context;
}
public static void EnsurePopulated(IApplicationBuilder application)
{
BookDBContext context = application.ApplicationServices.CreateScope().ServiceProvider.GetRequiredService <BookDBContext>();
if (context.Database.GetPendingMigrations().Any())
{
context.Database.Migrate();
}
if (!context.Books.Any())
{
context.Books.AddRange(
new Book
{
Title = "Les Miserables",
AuthorFirst = "Victor",
AuthorLast = "Hugo",
//AuthorMiddle = "",
Publisher = "Signet",
ISBN = "978-0451419439",
Classification = "Fiction",
Category = "Classic",
Price = 9.95,
PageLength = 1488
},
new Book
{
Title = "The Snowball",
AuthorFirst = "Alice",
AuthorLast = "Schroeder",
//AuthorMiddle = "",
Publisher = "Bantam",
ISBN = "978-0553384611",
Classification = "Non-Fiction",
Category = "Biography",
Price = 21.54,
PageLength = 832
},
new Book
{
Title = "Team of Rivals",
AuthorFirst = "Doris",
AuthorLast = "Goodwin",
AuthorMiddle = "Kearns",
Publisher = "Simon & Schuster",
ISBN = "978-0743270755",
Classification = "Non-Fiction",
Category = "Biography",
Price = 14.58,
PageLength = 944
},
new Book
{
Title = "American Ulysses",
AuthorFirst = "Ronald",
AuthorLast = "White",
AuthorMiddle = "C.",
Publisher = "Random House",
ISBN = "978-0812981254",
Classification = "Non-Fiction",
Category = "Biography",
Price = 11.61,
PageLength = 864
},
new Book
{
Title = "Unbroken",
AuthorFirst = "Laura",
AuthorLast = "Hillenbrand",
Publisher = "Random House",
ISBN = "978-0812974492",
Classification = "Non-Fiction",
Category = "Historical",
Price = 13.33,
PageLength = 528
},
new Book
{
Title = "The Great Train Robbery",
AuthorFirst = "Michael",
AuthorLast = "Crichton",
Publisher = "Vintage",
ISBN = "978-0804171281",
Classification = "Fiction",
Category = "Historical Fiction",
Price = 15.95,
PageLength = 288
},
new Book
{
Title = "Deep Work",
AuthorFirst = "Cal",
AuthorLast = "Newport",
Publisher = "Grand Central Publishing",
ISBN = "978-1455586691",
Classification = "Non-Fiction",
Category = "Self-Help",
Price = 14.99,
PageLength = 304
},
new Book
{
Title = "It's Your Ship",
AuthorFirst = "Michael",
AuthorLast = "Abrashoff",
Publisher = "Grand Central Publishing",
ISBN = "978-1455523023",
Classification = "Non-Fiction",
Category = "Self-Help",
Price = 21.66,
PageLength = 240
},
new Book
{
Title = "The Virgin Way",
AuthorFirst = "Richard",
AuthorLast = "Branson",
Publisher = "Portfolio",
ISBN = "978-1591847984",
Classification = "Non-Fiction",
Category = "Business",
Price = 29.16,
PageLength = 400
},
new Book
{
Title = "Sycamore Row",
AuthorFirst = "John",
AuthorLast = "Grisham",
Publisher = "Bantam",
ISBN = "978-0553393613",
Classification = "Fiction",
Category = "Thrillers",
Price = 15.03,
PageLength = 642
},
new Book
{
Title = "When Breath Becomes Air",
AuthorFirst = "Paul",
AuthorLast = "Kalanithi",
Publisher = "Random House",
ISBN = "978-0812988406",
Classification = "Non-Fiction",
Category = "Autobiography",
Price = 26.00,
PageLength = 256
},
new Book
{
Title = "The Way of Kings",
AuthorFirst = "Brandon",
AuthorLast = "Sanderson",
Publisher = "Tor Books",
ISBN = "978-0765326355",
Classification = "Fiction",
Category = "Fantasy",
Price = 23.64,
PageLength = 1005
},
new Book
{
Title = "The Boy, the Mole, the Fox and the Horse",
AuthorFirst = "Charlie",
AuthorLast = "Mackesy",
Publisher = "HarperCollins Publishers",
ISBN = "978-0062976581",
Classification = "Fiction",
Category = "Illustrated",
Price = 14.54,
PageLength = 128
}
);
context.SaveChanges();
}
}