[TestCase("3VWCC21C6YM431294")]  // can get vehicle w/all columns aligned correctly
        public void CanLoadVehiclesByVin(string vinNumber)
        {
            var repo             = new VehicleRepositoryADO();
            var requestedVehicle = repo.GetVehicleByVIN(vinNumber);

            if (requestedVehicle != null)
            {
                Assert.AreEqual(requestedVehicle.ModelID, 8);
                Assert.AreEqual(requestedVehicle.MakeID, 3);
                Assert.AreEqual(requestedVehicle.BodyStyleID, 1);
                Assert.AreEqual(requestedVehicle.TransmissionID, 1);
                Assert.AreEqual(requestedVehicle.ExteriorColor, 5);
                Assert.AreEqual(requestedVehicle.InteriorColor, 4);
                Assert.AreEqual(requestedVehicle.Mileage, 0);
                Assert.AreEqual(requestedVehicle.MSRP, 79990.00m);
                Assert.AreEqual(requestedVehicle.SalePrice, 75000.00m);
                Assert.AreEqual(requestedVehicle.Description, "A Tesla S!");
                Assert.AreEqual(requestedVehicle.Picture, "this is where the picture url goes");
                Assert.AreEqual(requestedVehicle.IsFeatured, false);
                Assert.AreEqual(requestedVehicle.IsPurchased, false);
            }
        }