예제 #1
0
        /// <summary>
        /// Each test will start by testing for an empty table, and each test
        /// will leave the database state as it found it.
        /// </summary>
        private void TruncatePersonTable()
        {
            // We have to work with what we have :)
            peopleProvider = new PeopleProvider();
            var people = peopleProvider.ListPeople();

            people.ToList().ForEach(p => peopleProvider.DeletePerson(p.ID));
        }
예제 #2
0
        public void SQLite_DeletePerson_CheckEmpty()
        {
            TruncatePersonTable();

            // Create one person
            var person = GetNewPerson("Joe", "Smith", 40);

            peopleProvider.CreatePerson(person);

            // Get ID
            var people = peopleProvider.ListPeople();
            var ID     = people.ToArray()[0].ID;

            // Delete
            peopleProvider.DeletePerson(ID);

            // Check all gone
            people = peopleProvider.ListPeople();

            Assert.AreEqual(0, people.Count(), $"Expected an empty table after delete, but found {people.Count()} item(s)", null);

            TruncatePersonTable();
        }