private ConsultantContext GetContextWithData()
        {
            var options = new DbContextOptionsBuilder <ConsultantContext>()
                          .UseInMemoryDatabase(Guid.NewGuid().ToString())
                          .Options;

            var context = new ConsultantContext(options);

            context.Consultants.Add(new Consultant("Louis", "Broucke", "Junior .NET Developer", "Mechelen", "*****@*****.**", "0478529462", new DateTime(1991, 09, 14)));
            context.Consultants.Add(new Consultant("Koen", "Hublet", "Operations Manager", "Gent", "*****@*****.**", "0478529462", new DateTime(1991, 09, 14)));
            context.Consultants.Add(new Consultant("Nele", "Goovaerts", "HR Manager", "Mechelen", "*****@*****.**", "0478529462", new DateTime(1991, 09, 14)));
            context.Consultants.Add(new Consultant("Seppe", "Van Brabant", "Sales Manager", "Antwerpen", "*****@*****.**", "0478529462", new DateTime(1991, 09, 14)));
            context.Consultants.Add(new Consultant("Noortje", "Vanbutsele", "Sales Manager", "Leuven", "*****@*****.**", "0478529462", new DateTime(1991, 09, 14)));
            context.SaveChanges();

            return(context);
        }
 public SQLConsultantRepository(ConsultantContext context)
 {
     this.context = context;
 }