public void VacationTest() { using (DatabaseSetup db = new DatabaseSetup(Utili.GetCurrentMethodAndClass())) { db.ClearTable(Vacation.TableName); db.ClearTable(VacationTime.TableName); Vacation vac = new Vacation("name", null, db.ConnectionString, 1, 99, CreationType.ManuallyCreated, Guid.NewGuid().ToStrGuid()); DateTime dt = new DateTime(2010, 1, 1); vac.SaveToDB(); vac.AddVacationTime(dt, dt, VacationType.GoAway); ObservableCollection <Vacation> vacations = new ObservableCollection <Vacation>(); Vacation.LoadFromDatabase(vacations, db.ConnectionString, false); (vacations.Count).Should().Be(1); Vacation v1 = vacations[0]; (v1.Name).Should().Be("name"); (v1.VacationTimes.Count).Should().Be(1); VacationTime vt = v1.VacationTimes[0]; (vt.Start).Should().Be(dt); (vt.End).Should().Be(dt); v1.DeleteVacationTime(vt); #pragma warning disable S1854 // Dead stores should be removed #pragma warning disable IDE0059 // Value assigned to symbol is never used v1 = null; // to enable garbage collection immidiately #pragma warning restore IDE0059 // Value assigned to symbol is never used #pragma warning restore S1854 // Dead stores should be removed ObservableCollection <Vacation> vacations1 = new ObservableCollection <Vacation>(); Vacation.LoadFromDatabase(vacations1, db.ConnectionString, false); (vacations.Count).Should().Be(1); Vacation v2 = vacations[0]; (v2.Name).Should().Be("name"); (v2.VacationTimes.Count).Should().Be(0); db.Cleanup(); } }