public void GetStudentsForGroups_Returns_CorrectNumber()
        {
            //  Arrange
            //  -------
            TestDb testContext = new TestDb();

            //  instantiate the repository class
            UserRepository repository = new UserRepository(testContext);
            string username = "******";

            //  Action
            //  ------
            List<User> group1students = repository.GetUsersForGroup(1, username).ToList<User>();
            List<User> group2students = repository.GetUsersForGroup(2, username).ToList<User>();
            List<User> group3students = repository.GetUsersForGroup(3, username).ToList<User>();
            List<User> group4students = repository.GetUsersForGroup(4, username).ToList<User>();
            List<User> group5students = repository.GetUsersForGroup(5, username).ToList<User>();
            List<User> group6students = repository.GetUsersForGroup(6, username).ToList<User>();
            List<User> group7students = repository.GetUsersForGroup(7, username).ToList<User>();
            List<User> group8students = repository.GetUsersForGroup(8, username).ToList<User>();
            List<User> group9students = repository.GetUsersForGroup(9, username).ToList<User>();
            List<User> group10students = repository.GetUsersForGroup(10, username).ToList<User>();
            List<User> group11students = repository.GetUsersForGroup(11, username).ToList<User>();

            //  Assert
            //  ------
            Assert.AreEqual(5 - 1, group1students.Count()); //  minus 1 as the method excludes Tim: the logged on user.
            Assert.AreEqual(8, group2students.Count());     //  Tim NOT member
            Assert.AreEqual(4, group3students.Count());     //  Tim NOT member
            Assert.AreEqual(9, group4students.Count());     //  Tim NOT member
            Assert.AreEqual(7, group5students.Count());     //  Tim NOT member
            Assert.AreEqual(5 - 1, group6students.Count()); //  Tim IS member
            Assert.AreEqual(3, group7students.Count());     //  Tim NOT member
            Assert.AreEqual(7, group8students.Count());     //  Tim NOT member
            Assert.AreEqual(6 - 1, group9students.Count()); //  Tim IS member
            Assert.AreEqual(4 - 1, group10students.Count());//  Tim IS member
            Assert.AreEqual(9 - 1, group11students.Count());//  Tim IS member
        }