public void CanGetDvdsByDirector() { var repo = new DvdRepositoryADO(); var dvds = repo.GetDvdByDirector("Some Guy"); Assert.IsNotNull(dvds); Assert.AreEqual(1, dvds.Count()); Assert.AreEqual("The Lion King", dvds[0].Title); Assert.AreEqual(1992, dvds[0].ReleaseYear); Assert.AreEqual("Some Guy", dvds[0].Director); Assert.AreEqual("PG", dvds[0].Rating); Assert.AreEqual("The best ever!", dvds[0].Notes); Dvd addToTest = new Dvd(); addToTest.DvdId = 3; addToTest.Title = "BobbyBuilderBanks"; addToTest.ReleaseYear = 2000; addToTest.Director = "Some Guy"; addToTest.Rating = "X"; addToTest.Notes = null; repo.CreateDvd(addToTest); dvds = repo.GetDvdByDirector("Some Guy"); Assert.AreEqual(2, dvds.Count()); }