Exemplo n.º 1
0
 //Constructor for the class
 public EFBookRepository(BookDBContext context)
 {
     _context = context;
 }
Exemplo n.º 2
0
        public static void EnsurePopulated(IApplicationBuilder application)
        {
            BookDBContext context = application.ApplicationServices.CreateScope().ServiceProvider.GetRequiredService <BookDBContext>();

            //If database has pending migrations then move those migrations into the database
            if (context.Database.GetPendingMigrations().Any())
            {
                context.Database.Migrate();
            }

            //If database does not have any books in it then populate it with the following data
            if (!context.Books.Any())
            {
                context.Books.AddRange(
                    new Book
                {
                    //BookId = 1,
                    Title             = "Les Miserables",
                    Author_First_Name = "Victor",
                    Author_Last_Name  = "Hugo",
                    Publisher         = "Signet",
                    ISBN           = "978-0451419439",
                    Classification = "Fiction",
                    Category       = "Classic",
                    Price          = 9.95,
                    Page_Num       = 1488
                },

                    new Book
                {
                    //BookId = 2,
                    Title             = "Team of Rivals",
                    Author_First_Name = "Doris",
                    Author_Middle_In  = "K",
                    Author_Last_Name  = "Goodwin",
                    Publisher         = "Simon & Schuster",
                    ISBN           = "978-0743270755",
                    Classification = "Non-Fiction",
                    Category       = "Biography",
                    Price          = 14.58,
                    Page_Num       = 944
                },

                    new Book
                {
                    //BookId = 3,
                    Title             = "The Snowball",
                    Author_First_Name = "Alice",
                    Author_Last_Name  = "Schroeder",
                    Publisher         = "Bantam",
                    ISBN           = "978-0553384611",
                    Classification = "Non-Fiction",
                    Category       = "Biography",
                    Price          = 21.54,
                    Page_Num       = 832
                },

                    new Book
                {
                    //BookId = 4,
                    Title             = "American Ulysses",
                    Author_First_Name = "Ronald",
                    Author_Middle_In  = "C",
                    Author_Last_Name  = "White",
                    Publisher         = "Random House",
                    ISBN           = "978-0812981254",
                    Classification = "Non-Fiction",
                    Category       = "Biography",
                    Price          = 11.61,
                    Page_Num       = 864
                },


                    new Book
                {
                    //BookId = 5,
                    Title             = "Unbroken",
                    Author_First_Name = "Laura",
                    Author_Last_Name  = "Hillenbrand",
                    Publisher         = "Random House",
                    ISBN           = "978-0812974492",
                    Classification = "Non-Fiction",
                    Category       = "Historical",
                    Price          = 13.33,
                    Page_Num       = 528
                },

                    new Book
                {
                    //BookId = 6,
                    Title             = "The Great Train Robbery",
                    Author_First_Name = "Michael",
                    Author_Last_Name  = "Crichton",
                    Publisher         = "Vintage",
                    ISBN           = "978-0804171281",
                    Classification = "Fiction",
                    Category       = "Historical Fiction",
                    Price          = 15.95,
                    Page_Num       = 288
                },

                    new Book
                {
                    //BookId = 7,
                    Title             = "Deep Work",
                    Author_First_Name = "Cal",
                    Author_Last_Name  = "Newport",
                    Publisher         = "Grand Central Publishing",
                    ISBN           = "978-1455586691",
                    Classification = "Non-Fiction",
                    Category       = "Self-Help",
                    Price          = 14.99,
                    Page_Num       = 304
                },

                    new Book
                {
                    //BookId = 8,
                    Title             = "It's Your Ship",
                    Author_First_Name = "Michael",
                    Author_Last_Name  = "Abrashoff",
                    Publisher         = "Grand Central Publishing",
                    ISBN           = "978-1455523023",
                    Classification = "Non-Fiction",
                    Category       = "Self-Help",
                    Price          = 21.66,
                    Page_Num       = 240
                },

                    new Book
                {
                    //BookId = 9,
                    Title             = "The Virgin Way",
                    Author_First_Name = "Richard",
                    Author_Last_Name  = "Branson",
                    Publisher         = "Portfolio",
                    ISBN           = "978-1591847984",
                    Classification = "Non-Fiction",
                    Category       = "Business",
                    Price          = 29.16,
                    Page_Num       = 400
                },

                    new Book
                {
                    //BookId = 10,
                    Title             = "Sycamore Row",
                    Author_First_Name = "John",
                    Author_Last_Name  = "Grisham",
                    Publisher         = "Bantam",
                    ISBN           = "978-0553393613",
                    Classification = "Fiction",
                    Category       = "Thrillers",
                    Price          = 15.03,
                    Page_Num       = 642
                },

                    new Book
                {
                    //BookId = 11,
                    Title             = "The Name of the Wind",
                    Author_First_Name = "Patrick",
                    Author_Last_Name  = "Rothfuss",
                    Publisher         = "Penguin Books",
                    ISBN           = "978-0583493633",
                    Classification = "Fiction",
                    Category       = "Fantasy",
                    Price          = 35.99,
                    Page_Num       = 488
                },

                    new Book
                {
                    //BookId = 12,
                    Title             = "The Great Gatsby",
                    Author_First_Name = "F",
                    Author_Middle_In  = "S",
                    Author_Last_Name  = "Fitzgerald",
                    Publisher         = "Squire & Co.",
                    ISBN           = "978-0533933660",
                    Classification = "Fiction",
                    Category       = "Drama",
                    Price          = 13.99,
                    Page_Num       = 153
                },

                    new Book
                {
                    //BookId = 13,
                    Title             = "Brave New World",
                    Author_First_Name = "Aldous",
                    Author_Last_Name  = "Huxley",
                    Publisher         = "Chatto and Windus",
                    ISBN           = "978-0559334113",
                    Classification = "Fiction",
                    Category       = "Dystopia",
                    Price          = 5.99,
                    Page_Num       = 121
                }
                    );

                //Save changes
                context.SaveChanges();
            }
        }