public void Setup() { var services = ServiceProviderBuilder.GetServiceProviderArgumentless(); var options = services.GetRequiredService <IOptions <MyOptions> >(); string connectionString = options.Value.SecretOption; /*var dao = new DailySettingsDAO(); * string connectionString = dao.GetConnectionString();*/ databaseConnectionString = connectionString; trans = new TransactionScope(); using (SqlConnection conn = new SqlConnection(connectionString)) { conn.Open(); string sql_insert = "Insert Into daily_settings (day_of_year, time_period, rotors, reflectors, beta_or_gamma, offset, plugs, start_position) Values(1,0,'VIII III I','B','Gamma','8 3 4','X Z J O V K Y L D F I E W C P Q B S U A', 'O G P G');" + "Insert Into daily_settings (day_of_year, time_period, rotors, reflectors, beta_or_gamma, offset, plugs, start_position) Values(1,8,'VII II III','C','Beta','2 12 6','O Y H E G X J D S R Z T B I K N V U M P', 'G Z S Y');" + "Insert Into daily_settings (day_of_year, time_period, rotors, reflectors, beta_or_gamma, offset, plugs, start_position) Values(1,16,'II V I','B','Gamma','10 24 18','Q P N K I M H W X F L Y G Z R D C J O B', 'R T E E');" + "Insert Into daily_settings (day_of_year, time_period, rotors, reflectors, beta_or_gamma, offset, plugs, start_position) Values(2,0,'III VI VII','C','Gamma','19 20 21','A Q B Z V W H D Y N L J U K G O M C E I', 'O W F V');" + "Insert Into daily_settings (day_of_year, time_period, rotors, reflectors, beta_or_gamma, offset, plugs, start_position) Values(2,8,'II I IV','B','Gamma','23 16 19','F I M K N Q Z B W T S G X R P H L J D E', 'D P A A');" + "Insert Into daily_settings (day_of_year, time_period, rotors, reflectors, beta_or_gamma, offset, plugs, start_position) Values(2,16,'V III VIII','C','Gamma','4 12 21','I H L P Y S R D M W O Z B N U F Q K C A', 'I J A Y');"; SqlCommand cmd = new SqlCommand(sql_insert, conn); int count = cmd.ExecuteNonQuery(); Assert.AreEqual(6, count, "Insert into daily_settings failed."); } }