public void UserConfigurationPersisterRemoveTest() { var config = new UserConfiguration(); config.AllowSeeking = false; config.CacheArt = false; config.CacheSongs = true; config.Password = @"password's"; config.User = "******"; config.ServerUrl = "testserver"; var conn = new SQLiteConnection("Data Source=:memory:"); using(var cmd = conn.CreateCommand()) using(var target = new UserConfigurationPersister(conn)){ target.Remove(config); string format = @"select value from properties where key = '{0}';"; cmd.CommandText = string.Format(format, "url"); Assert.That(cmd.ExecuteScalar(), Is.EqualTo(string.Empty)); cmd.CommandText = string.Format(format, "user"); Assert.That(cmd.ExecuteScalar(), Is.EqualTo(String.Empty)); cmd.CommandText = string.Format(format, "password"); Assert.That(cmd.ExecuteScalar(), Is.EqualTo(string.Empty)); cmd.CommandText = string.Format(format, "allowSeeking"); Assert.That(bool.Parse(cmd.ExecuteScalar().ToString()), Is.True); cmd.CommandText = string.Format(format, "cacheArt"); Assert.That(bool.Parse(cmd.ExecuteScalar().ToString()), Is.True); } }