public void GetCustomerIDReturnsCustomerID()
        {
            var options = new DbContextOptionsBuilder <SGDB2Context>()
                          .UseInMemoryDatabase(databaseName: "SGDB2")
                          .Options;

            using (var context = new SGDB2Context(options))
            {
                var result = StoreMethods.GetCustomerIDs(context);
                Assert.IsType <List <int> >(result);
            }
        }//6
        public void GetHighestIDIncrements()
        {
            var options = new DbContextOptionsBuilder <SGDB2Context>()
                          .UseInMemoryDatabase(databaseName: "SGDB2")
                          .Options;

            using (var context = new SGDB2Context(options))
            {
                var custID = StoreMethods.GetCustomerIDs(context);
                var result = StoreMethods.GetNewCustID(custID);
                custID.Add(result);
                var result1 = StoreMethods.GetNewCustID(custID);

                Assert.True(result1 != result);
            }
        }//9
        public void GetCustomerIDReturnsPopulatedList()
        {
            var options = new DbContextOptionsBuilder <SGDB2Context>()
                          .UseInMemoryDatabase(databaseName: "SGDB2")
                          .Options;

            using (var context = new SGDB2Context(options))
            {
                Customers customer = new Customers {
                    CustomerId = 200
                };
                context.Customers.Add(customer);
                context.SaveChanges();
                List <int> result  = StoreMethods.GetCustomerIDs(context);
                int        isEmpty = result.Count;
                Assert.True(result.Count > 0);
            }
        }//7