public void RetrieveValueStringTest()
        {
            // Arrange
            var repository = new VendorRepository();
            var expected = "default value";

            // Act
            var actual = repository.RetrieveValue("Select...", "default value");

            // Assert
            Assert.AreEqual(expected, actual);
        }
        public void RetrieveValueTestWithString()
        {
            //Arrange
            var repo = new VendorRepository();
            var expected = "* From People Where Name == 'Ronald'";

            //Act
            var actual = repo.RetrieveValue<string>("Select  ...", "* From People Where Name == 'Ronald'");

            //Assert
            Assert.AreEqual(expected, actual);
        }
        public void RetrieveValueIntTest()
        {
            // Arrange
            var repository = new VendorRepository();
            var expected = 42;

            // Act
            var actual = repository.RetrieveValue<int>("Select...", 42);

            // Assert
            Assert.AreEqual(expected, actual);
        }
        public void RetrieveValueTestWithInt()
        {
            //Arrange
            var repo = new VendorRepository();
            var expected = 32;

            //Act
            var actual = repo.RetrieveValue<int>("Select  ...", 32);

            //Assert
            Assert.AreEqual(expected, actual);
        }