public static async void InsertMatchesToDatabaseAsync(int rows) { List <string> commandsToTextFile = new List <string>(); List <int> clubIds = new List <int>(); List <int> gameIds = new List <int>(); clubIds.Clear(); gameIds.Clear(); clubIds = GetIds("id_klubu", "Kluby"); gameIds = GetIds("id_kolejki", "Kolejka"); for (int i = 0; i < rows; i++) { var commandText = "insert into Mecze (Kolejka_id_kolejki, Kluby_id_klubu, id_gosc, data_i_godzina, wynik) values(:Kolejka_id_kolejki, :Kluby_id_klubu, :id_gosc, :data_i_godzina, :wynik)"; using (OracleConnection connection = new OracleConnection(SqlConnection.connectionString)) { using (OracleCommand command = new OracleCommand(commandText, connection)) { command.Parameters.Add(new OracleParameter("Kolejka_id_kolejki", gameIds[RandomElements.GetRandomNumber(0, gameIds.Count - 1)])); command.Parameters.Add(new OracleParameter("Kluby_id_klubu", clubIds[RandomElements.GetRandomNumber(0, clubIds.Count - 1)])); command.Parameters.Add(new OracleParameter("id_gosc", clubIds[RandomElements.GetRandomNumber(0, clubIds.Count - 1)])); command.Parameters.Add(new OracleParameter("data_i_godzina", RandomElements.GetRandomDate(2018, 2021, "yyyy-MM-dd HH:mm:ss"))); command.Parameters.Add(new OracleParameter("wynik", Convert.ToString(RandomElements.GetRandomResult()))); commandsToTextFile.Add("insert into Mecze (Kolejka_id_kolejki, Kluby_id_klubu, id_gosc, data_i_godzina, wynik) " + "values(" + command.Parameters[0].Value.ToString() + ", " + command.Parameters[1].Value.ToString() + ", " + command.Parameters[2].Value.ToString() + ", " + command.Parameters[3].Value.ToString() + ", " + command.Parameters[4].Value.ToString() + ")"); command.Connection.Open(); await command.ExecuteNonQueryAsync(); command.Connection.Close(); } } } WriteCommandsToTextFile("Mecze", commandsToTextFile); clubIds.Clear(); }