title: C# Application freezes at adding the SQLite query results to List<string>
body: <p>I have a query which returns 66 rows, each of these rows contains a unique_id and I want to save the results in a List so I can use them for further queries. But the code freezes at the line which is supposed to add the rows to the list. I can't find where my problem is! This is My code:</p>
  
  <pre><code>public List&lt;string&gt; unique_id;
  public List&lt;string&gt; get_unique_id_connection()
      {
          SQLiteConnection m_dbConnection;
          m_dbConnection = new SQLiteConnection("Data Source=akm.sqlite;version=3;");
  
          m_dbConnection.Open();
          string sql2 = "SELECT unique_id FROM mos_tbl WHERE region = 10";
          SQLiteCommand command2 = new SQLiteCommand(sql2, m_dbConnection);
          SQLiteDataReader rdr2 = null;
          rdr2 = command2.ExecuteReader();
          while (rdr2.Read())
          {
              for (int i = 0; i &lt; rdr2.FieldCount; i++)
              {
                  //MessageBox.Show(rdr2.GetValue(i).ToString());
                  unique_id.Add(rdr2.GetValue(i).ToString());//This is where it freezes
              }
          }
          return unique_id;
      }
  </code></pre>
  
  <p>When I uncomment the MessageBox I can see the correct results, so I guess the problem is not the query.</p>