public void ShouldGetLatestPhoto() { //arrange var numOfDaysBefore = 1; var dateTo = DateTime.Now; var dateFrom = DateTime.Now.Subtract(new TimeSpan(numOfDaysBefore, 0, 0, 0)); //act var dataLayer = new DataLayer.Sql.DataLayer(ConnectionSql); List <Photo> latestPhotos = dataLayer.GetLatestPhotos(dateFrom, dateTo); var wrongDate = false; foreach (var latestPhoto in latestPhotos) { if ((latestPhoto.TimeDate < dateFrom) || (latestPhoto.TimeDate > dateTo)) { wrongDate = true; } } //assert Assert.AreEqual(wrongDate, false); }