public void Data_Read_User_By_Email()
        {
            var repository = new UserRepository(_dataConnectionString, 1);

            var data = repository.GetByEmailAddress("*****@*****.**");

            Assert.IsTrue(data.UserID == 1);
            Assert.IsTrue(data.Forename == "Test");
            Assert.IsTrue(data.Surname == "User");
        }
        public void Data_Read_Deleted_User_By_Email()
        {
            var repository = new UserRepository(_dataConnectionString, 1);

            var data = repository.GetByEmailAddress("*****@*****.**");

            Assert.IsTrue(data == null);
        }