public void GetLocation()
        {
            //putting in a test context/ connection to our test db
            using (var context = new DataLogic.StoreDBContext(options))
            {
                //Arrange
                DataLogic.storeDB _repo = new DataLogic.storeDB(context);

                //Act
                Location location = _repo.FIndLocation("Scranton");

                //Assert
                Assert.Equal(1, location.LocationId);
            }
        }
        //When testing operations that change the state of the db (i.e manipulate the data inside the db)
        //make sure to check if the change has persisted even when accessing the db using a different context/connection
        //This means that you create another instance of your context when testing to check that the method has
        //definitely affected the db.
        //What operations affect the state of the db? Create, Update, Delete
        private void Seed()
        {
            using (var context = new DataLogic.StoreDBContext(options))
            {
                context.Database.EnsureDeleted();
                context.Database.EnsureCreated();
                context.Locations.Add(
                    new Location {
                    LocationId = 1,
                    Name       = "Scranton",
                    Address    = "5354 West Pickle St. Scranton, OH 99849"
                }

                    );
                context.Products.Add(
                    new Product {
                    ProductId = 1,
                    Name      = "Dirt",
                    Price     = 5.99
                }
                    );
                context.SaveChanges();
            }
        }
 public storeDB(StoreDBContext context)
 {
     _context = context;
 }