public static void EnsurePopulated(IApplicationBuilder application)
        {
            ProductDbContext context = application.ApplicationServices.CreateScope().ServiceProvider.GetRequiredService <ProductDbContext>();

            if (context.Database.GetPendingMigrations().Any())
            {
                context.Database.Migrate();
            }

            if (!context.Projects.Any())
            {
                context.Projects.AddRange(

                    new Product
                {
                    Title       = "Les Miserables",
                    AuthorFirst = "Victor",
                    AuthorLast  = "Hugo",
                    Publisher   = "Signet",
                    ISBN        = "978-0451419439",
                    Category    = "Fiction, Classic",
                    Price       = "$9.95"
                },

                    new Product
                {
                    Title       = "Team of Rivals",
                    AuthorFirst = "Doris Kearns",
                    AuthorLast  = "Goodwin",
                    Publisher   = "Simon & Schuster",
                    ISBN        = "978-0743270755",
                    Category    = "Non-Fiction, Biography",
                    Price       = "$14.58"
                },

                    new Product
                {
                    Title       = "The Snowball",
                    AuthorFirst = "Alice",
                    AuthorLast  = "Schroeder",
                    Publisher   = "Bantam",
                    ISBN        = "978-0553384611",
                    Category    = "Non-Fiction, Biography",
                    Price       = "$21.54"
                }

                    );
                context.SaveChanges();
            }
        }
        //constructor

        public EFProductRepository(ProductDbContext context)
        {
            _context = context;
        }
        public static void EnsurePopulated(IApplicationBuilder application)
        {
            ProductDbContext context = application.ApplicationServices.CreateScope().ServiceProvider.GetRequiredService <ProductDbContext>();

            if (context.Database.GetPendingMigrations().Any())
            {
                context.Database.Migrate();
            }


            //add seed data
            if (!context.Projects.Any())
            {
                context.Projects.AddRange(

                    new Product
                {
                    Title       = "Les Miserables",
                    AuthorFirst = "Victor",
                    AuthorLast  = "Hugo",
                    Publisher   = "Signet",
                    ISBN        = "978-0451419439",
                    Category    = "Fiction, Classic",
                    Price       = "$9.95",
                    pages       = 1488
                },

                    new Product
                {
                    Title       = "Team of Rivals",
                    AuthorFirst = "Doris Kearns",
                    AuthorLast  = "Goodwin",
                    Publisher   = "Simon & Schuster",
                    ISBN        = "978-0743270755",
                    Category    = "Non-Fiction, Biography",
                    Price       = "$14.58",
                    pages       = 944
                },

                    new Product
                {
                    Title       = "The Snowball",
                    AuthorFirst = "Alice",
                    AuthorLast  = "Schroeder",
                    Publisher   = "Bantam",
                    ISBN        = "978-0553384611",
                    Category    = "Non-Fiction, Biography",
                    Price       = "$21.54",
                    pages       = 832
                },

                    new Product
                {
                    Title       = "Lone Survior",
                    AuthorFirst = "Navy",
                    AuthorLast  = "Seal",
                    Publisher   = "Bantam",
                    ISBN        = "978-0553384611",
                    Category    = "Non-Fiction",
                    Price       = "$20000.54",
                    pages       = 40
                },

                    new Product
                {
                    Title       = "Eye of the World",
                    AuthorFirst = "Robert",
                    AuthorLast  = "Jordan",
                    Publisher   = "Your mom",
                    ISBN        = "978-0553384611",
                    Category    = "Fiction",
                    Price       = "$2.54",
                    pages       = 800
                },

                    new Product
                {
                    Title       = "Disipline Equals Freedom",
                    AuthorFirst = "Jocko",
                    AuthorLast  = "Willink",
                    Publisher   = "Bantam",
                    ISBN        = "978-0553384611",
                    Category    = "Non-Fiction",
                    Price       = "$20.54",
                    pages       = 300
                }

                    );
                context.SaveChanges();
            }
        }