public static void Initialize(IServiceProvider serviceProvider)
        {
            using (var context = new MakeupContext(
                       serviceProvider.GetRequiredService <DbContextOptions <MakeupContext> >()))
            {
                // Look for any movies.
                if (context.Makeup.Any())
                {
                    return;   // DB has been seeded
                }

                context.Makeup.AddRange(
                    new Makeup
                {
                    Product_Id   = 1,
                    Product_Name = "DIORSHOW",
                    Brand        = "Dior",
                    Price        = 38.28,
                    Type         = "MASCARA",

                    Retailer_Id = 1,
                    Link        = "https://www.dior.com/beauty/nl_be/parfum-en-beauty/make-up/ogen/mascara/pr-mascaras-y0697400-de-volumemascara-waarmee-het-lijkt-of-er-nieuwe-wimpers-ontstaan.html"
                },
                    new Makeup
                {
                    Product_Id   = 1,
                    Product_Name = "DIORSHOW",
                    Brand        = "Dior",
                    Price        = 33.50,
                    Type         = "MASCARA",
                    Retailer_Id  = 2,
                    Link         = "https://www.iciparisxl.be/nl/dior/diorshow-pro-black/mascara/p/BP_748850"
                },
                    new Makeup
                {
                    Product_Id   = 1,
                    Product_Name = "DIORSHOW",
                    Brand        = "Dior",
                    Price        = 34.99,
                    Type         = "MASCARA",
                    Retailer_Id  = 3,
                    Link         = "https://www.bol.com/nl/p/dior-diorshow-mascara-090-pro-black/9200000029322328/?country=BE"
                },
                    new Makeup
                {
                    Product_Id   = 2,
                    Product_Name = "MSCRPRIMER",
                    Brand        = "Dior",
                    Price        = 34.43,
                    Type         = "PRIMER",
                    Retailer_Id  = 1,
                    Link         = "https://www.dior.com/beauty/nl_be/parfum-en-beauty/make-up/ogen/eyes-primers/pr-eyeprimers-y0697970-serum-mascarabasis-booster-effect-volume-van-de-wimpers-x3.html"
                },
                    new Makeup
                {
                    Product_Id   = 2,
                    Product_Name = "MSCRPRIMER",
                    Brand        = "Dior",
                    Price        = 32.90,
                    Type         = "PRIMER",
                    Retailer_Id  = 2,
                    Link         = "https://www.iciparisxl.be/nl/dior/diorshow-maximizer-3d/plumping-lash-primer/p/BP_812557"
                },
                    new Makeup
                {
                    Product_Id   = 2,
                    Product_Name = "MSCRPRIMER",
                    Brand        = "Dior",
                    Price        = 19.99,
                    Type         = "PRIMER",
                    Retailer_Id  = 4,
                    Link         = "https://www.kruidvat.be/nl/dior-diorshow-maximizer-3d-lash-volume-x3-base-serum-de-mascara/p/4370220?country=BE"
                }

                    );



                context.SaveChanges();
            }
            using (var context1 = new RetailerContext(
                       serviceProvider.GetRequiredService <DbContextOptions <RetailerContext> >()))
            {
                // Look for any movies.
                if (context1.Retailer.Any())
                {
                    return;   // DB has been seeded
                }

                context1.Retailer.AddRange(

                    new Retailer
                {
                    Retailer_Name = "www.Dior.be",
                    Retailer_id   = 1
                },
                    new Retailer
                {
                    Retailer_id   = 2,
                    Retailer_Name = "www.iciparisxl.be"
                },
                    new Retailer
                {
                    Retailer_id   = 3,
                    Retailer_Name = "www.bol.com"
                },
                    new Retailer
                {
                    Retailer_id   = 4,
                    Retailer_Name = "www.kruidvat.be"
                }


                    );
                context1.SaveChanges();
            }
        }