private static void InsertSetting3(SQLiteCommand command, string environment, string version) { command.CommandText = ResourceReader.ReadEmbeddedResource <ConfiguationTestSQLite>("Resources.Insert Setting3.sql"); command.Parameters.Clear(); command.Parameters.Add("@Name", DbType.String, 200); command.Parameters.Add("@Value", DbType.String, -1); command.Parameters.Add("@Environment", DbType.String, 50); command.Parameters.Add("@Version", DbType.String, 50); foreach (var setting in SettingFactory.ReadSettings()) { command.Parameters["@Name"].Value = setting.Name.ToString(); command.Parameters["@Value"].Value = setting.Value.ToString().Recode(Encoding.UTF8, Encoding.Default); command.Parameters["@Environment"].Value = environment; command.Parameters["@Version"].Value = version; command.ExecuteNonQuery(); } }
public static void ResetData() { var baseKey = Microsoft.Win32.Registry.CurrentUser; using (var subKey = baseKey.OpenSubKey(@"Software\SmartConfig", writable: true)) { if (subKey != null && subKey.GetSubKeyNames().Contains("Tests", StringComparer.OrdinalIgnoreCase)) { subKey.DeleteSubKeyTree("Tests"); } } foreach (var setting in SettingFactory.ReadSettings()) { //var registryPath = setting.Id.Context.Join("\\"); //var subKeyName = Path.Combine(TestRegistryKey, registryPath); using (var subKey = baseKey.CreateSubKey(TestRegistryKey, writable: true)) { subKey.SetValue(setting.Name.ToString(), setting.Value); } } }