public void PlainTextTest()
        {
            var database = new SqlUserDatabase(new SqlConnectionStringProviderMock()
            {
                ConnectionStringValue = SqlUserDatabaseTests.connectionString
            });
            var service = new PlainTextPasswordService(database);

            ExecuteCommon(database, service);
        }
        public void FullCycleTest()
        {
            var database = new SqlUserDatabase(new SqlConnectionStringProviderMock()
            {
                ConnectionStringValue = connectionString
            });

            database.DeleteAll();
            const int    userId       = 999;
            const string userName     = "******";
            const string userPass     = "******";
            const string newUserPass  = "******";
            var          originalUser = new User()
            {
                UserId   = userId,
                UserName = userName,
                UserPass = userPass
            };

            database.Create(originalUser);
            var readUser = database.Read(userId);

            Assert.Equal(userId, readUser.UserId);
            Assert.Equal(userName, readUser.UserName);
            Assert.Equal(userPass, readUser.UserPass);
            readUser.UserPass = newUserPass;
            database.Update(readUser);
            var updatedUser = database.Read(userId);

            Assert.Equal(userId, readUser.UserId);
            Assert.Equal(userName, readUser.UserName);
            Assert.Equal(newUserPass, readUser.UserPass);
            database.Delete(userId);
            var deletedUser = database.Read(userId);

            Assert.Null(deletedUser);
        }