public void SetUp()
        {
            // create a record using straight EF
            using (var db = new AdventureWorksEntities())
            {
                var d = new Department() {
                     Name = "Ignorance",
                     GroupName = "Information Technology",
                     ModifiedDate = DateTime.Today
                };
                db.Departments.Add(d);
                db.SaveChanges();

                this.TestDepartmentID = d.DepartmentID;
            }
        }
 public void TearDown()
 {
     // delete the test record using straight EF
     using (var db = new AdventureWorksEntities())
     {
         var d = db.Departments.Find(this.TestDepartmentID);
         db.Departments.Remove(d);
         db.SaveChanges();
     }
 }