public void GetManufacturerAndProductNamePairs_Query_Returns_Many_Product_Manufacturer()
        {
            var productAndManufacturerPairs = _manufacturersRepository.GetManufacturerAndProductNamePairs_Query();

            Assert.AreEqual(2, productAndManufacturerPairs.Count());
            foreach (var productAndManufacturerPair in productAndManufacturerPairs)
            {
                Assert.IsNotNull(productAndManufacturerPair.Item1);
                Assert.IsNotNull(productAndManufacturerPair.Item2);
            }
        }