private static void InsertSetting3(SQLiteCommand command)
{
command.CommandText = ResourceReader.ReadEmbeddedResource <ConfigurationTest_SQLite>("Resources.InsertSetting3.sql");
command.Parameters.Clear();
command.Parameters.Add("@Name", DbType.String, 50);
command.Parameters.Add("@Value", DbType.String, -1);
command.Parameters.Add("@Environment", DbType.String, 50);
command.Parameters.Add("@Config", DbType.String, 50);
foreach (var testSetting in TestSettingFactory.CreateTestSettings3())
{
command.Parameters["@Name"].Value = testSetting.Name;
command.Parameters["@Value"].Value = testSetting.Value.Recode(Encoding.UTF8, Encoding.Default);
command.Parameters["@Environment"].Value = testSetting.Tags["Environment"];
command.Parameters["@Config"].Value = testSetting.Tags["Config"];
command.ExecuteNonQuery();
}
}
private static void InsertSetting3(SqlCommand sqlCommand)
{
sqlCommand.CommandText = ResourceReader.ReadEmbeddedResource <ConfigurationTest_SqlServer>("Resources.InsertSetting3.sql");
sqlCommand.Parameters.Clear();
sqlCommand.Parameters.Add("@Name", SqlDbType.NVarChar, 50);
sqlCommand.Parameters.Add("@Value", SqlDbType.NVarChar, -1);
sqlCommand.Parameters.Add("@Environment", SqlDbType.NVarChar, 50);
sqlCommand.Parameters.Add("@Config", SqlDbType.NVarChar, 50);
foreach (var testSetting in TestSettingFactory.CreateTestSettings3())
{
sqlCommand.Parameters["@Name"].Value = testSetting.Name;
sqlCommand.Parameters["@Value"].Value = testSetting.Value;
sqlCommand.Parameters["@Environment"].Value = testSetting.Tags["Environment"];
sqlCommand.Parameters["@Config"].Value = testSetting.Tags["Config"];
sqlCommand.ExecuteNonQuery();
}
}
