//Constructor for the class
 public EFBookRepository(BookDBcontext context)
 {
     _context = context;
 }
示例#2
0
        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(
                    //Populates the database with seed data
                    new Book
                {
                    Title           = "Les Miserables",
                    AuthorFirstName = "Victor",
                    AuthorLastName  = "Hugo",
                    Publisher       = "Signet",
                    ISBN            = "978-0451419439",
                    Classification  = "Fiction",
                    Category        = "Classic",
                    Price           = 9.95,
                    PageNumber      = 1488
                },
                    new Book
                {
                    Title               = "Team of Rivals",
                    AuthorFirstName     = "Doris",
                    AuthorMiddleInitial = "K.",
                    AuthorLastName      = "Goodwin",
                    Publisher           = "Simon and Schuster",
                    ISBN           = "978-0743270755",
                    Classification = "Non-Fiction",
                    Category       = "Biography",
                    Price          = 14.58,
                    PageNumber     = 944
                },
                    new Book
                {
                    Title           = "The Snowball",
                    AuthorFirstName = "Alice",
                    AuthorLastName  = "Schroeder",
                    Publisher       = "Bantam",
                    ISBN            = "978-0553384611",
                    Classification  = "Non-Fiction",
                    Category        = "Biography",
                    Price           = 21.54,
                    PageNumber      = 832
                },
                    new Book
                {
                    Title               = "American Ulysses",
                    AuthorFirstName     = "Ronald",
                    AuthorMiddleInitial = "C.",
                    AuthorLastName      = "White",
                    Publisher           = "Random House",
                    ISBN           = "978-0812981254",
                    Classification = "Non-Fiction",
                    Category       = "Biography",
                    Price          = 11.61,
                    PageNumber     = 864
                },
                    new Book
                {
                    Title           = "Unbroken",
                    AuthorFirstName = "Laura ",
                    AuthorLastName  = "Hillenbrand",
                    Publisher       = "Random House",
                    ISBN            = "978-0812974492",
                    Classification  = "Non-Fiction",
                    Category        = "Historical ",
                    Price           = 13.33,
                    PageNumber      = 528
                },
                    new Book
                {
                    Title           = "The Great Train Robbery",
                    AuthorFirstName = "Michael",
                    AuthorLastName  = "Crichton",
                    Publisher       = "Vintage",
                    ISBN            = "978-0804171281",
                    Classification  = "Fiction",
                    Category        = "Historical Fiction",
                    Price           = 15.95,
                    PageNumber      = 288
                },

                    new Book
                {
                    Title           = "Deep Work",
                    AuthorFirstName = "Cal",
                    AuthorLastName  = "Newport",
                    Publisher       = "Grand Central Publishing",
                    ISBN            = "978-1455586691",
                    Classification  = "Non-Fiction",
                    Category        = "Self-Help",
                    Price           = 14.99,
                    PageNumber      = 304
                },

                    new Book
                {
                    Title           = "It's Your Ship",
                    AuthorFirstName = "Michael",
                    AuthorLastName  = "Abrashoff",
                    Publisher       = "Grand Central Publishing",
                    ISBN            = "978-1455523023",
                    Classification  = "Non-Fiction",
                    Category        = "Self-Help",
                    Price           = 21.66,
                    PageNumber      = 240
                },
                    new Book
                {
                    Title           = "The Virgin Way",
                    AuthorFirstName = "Richard",
                    AuthorLastName  = "Branson",
                    Publisher       = "Portfolio",
                    ISBN            = "978-1591847984",
                    Classification  = "Non-Fiction",
                    Category        = "Business",
                    Price           = 29.16,
                    PageNumber      = 400
                },
                    new Book
                {
                    Title           = "Sycamore Row",
                    AuthorFirstName = "John",
                    AuthorLastName  = "Grisham",
                    Publisher       = "Bantam",
                    ISBN            = "978-0553393613",
                    Classification  = "Fiction",
                    Category        = "Thrillers",
                    Price           = 15.03,
                    PageNumber      = 642
                },
                    new Book
                {
                    Title           = "Flags of our Fathers",
                    AuthorFirstName = "James",
                    AuthorLastName  = "Bradley",
                    Publisher       = "Random House",
                    ISBN            = "978-0440229209",
                    Classification  = "Non-Fiction",
                    Category        = "Biography",
                    Price           = 17.52,
                    PageNumber      = 244
                },
                    new Book
                {
                    Title               = "Dustoff: The Memoir of an Army Aviator",
                    AuthorFirstName     = "Mike",
                    AuthorLastName      = "Novosel",
                    AuthorMiddleInitial = "J.",
                    Publisher           = "Presidio Press",
                    ISBN           = " 978-0891418023",
                    Classification = "Non-Fiction",
                    Category       = "Biography",
                    Price          = 12.61,
                    PageNumber     = 384
                },
                    new Book
                {
                    Title           = "The Red Badge of Courage",
                    AuthorFirstName = "Stephen",
                    AuthorLastName  = "Crane",
                    Publisher       = "CreateSpace",
                    ISBN            = "978-1508482765",
                    Classification  = "Historical Fiction",
                    Category        = "War",
                    Price           = 5.99,
                    PageNumber      = 88
                }

                    );

                context.SaveChanges();
            }
        }