public void ProjectRepository_Delete_ShouldRemoveAProjectFromTheDB()
        {
            var project = new Project();
            project.DateStarted = DateTime.Now;
            project.Name = "test";
            project.Owner = user;
            project.OwnerID = user.UserId;

            var repo = new ProjectRepository();
            repo.Create(project);

            Assert.IsNotNull(repo.FindProjectByID(project.ID));

            repo.Delete(project);
            Assert.IsNull(repo.FindProjectByID(project.ID));
        }
 /// <summary>
 /// removes existing proejcts from teh database so we can count the projects correctly
 /// </summary>
 /// <param name="userID"></param>
 private void removeExistingProjectsFromUser(int userID)
 {
     var projects = new ProjectRepository();
     var ownedProjects = projects.FindProjectsOwnedByUser(userID);
     foreach (var project in ownedProjects)
     {
         var foundProject = projects.FindProjectByID(project.ID);
         projects.Delete(foundProject);
     }
 }