title: Can I Fill a List using a DataAdapter C#
body: <p>Suppose I have this code (pseudocode)</p>
  
  <pre><code>class SomeClass
  {
     class Person
     {
        public static string Name { get; set; }
        public static int Age { get; set; }
     }
  
     List&lt;Person&gt; person = new List&lt;person&gt;;
  
     public void SelectPerson()
     {
        DataTable dt = new DataTable();
  
        SqlConnection conn = GetConnection();
        conn.Open();
  
        SqlDataAdapter da = new SqlDataAdapter("SELECT name, age FROM person", conn);
        da.Fill(dt);
     }
  }
  </code></pre>
  
  <p>Can I fill the List (person) based on the result of my DataAdapter?
  How should I do it? Or is there any workaround? Thanks...</p>