Exemplo n.º 1
0
        public void BetweenDatesFromPeopleTable()
        {
            var ops = new SqlOperations(TestCatalog);
            var expectedRowCount = 374;

            var startDate = new DateTime(1974, 1, 2, 1, 12, 0);
            var endDate   = new DateTime(1984, 1, 2, 1, 12, 0);

            var dtPeople = ops.FindBetweenBirthDay(startDate, endDate);

            Assert.IsTrue(dtPeople.Rows.Count == expectedRowCount,
                          $"Expected {expectedRowCount} rows but" +
                          $"returned {dtPeople.Rows.Count} rows");
        }