title: How to add multiple property into a List of IEnumerable<Student>
body: <p>I have created a class <code>Student</code> and in the class it has those properties:</p>
  
  <pre><code>      class Student: IEnumerable&lt;Student&gt;
      {
      private int age =0 ;
      private string name ="";
      private bool isAdult = false;
  
  
  List&lt;Student&gt; StudentList = new List&lt;Student&gt;();
  
          public Student this[int index]
          {
              get { return StudentList [index]; }
              set { StudentList .Insert(index, value); }
          }
  
          public IEnumerator&lt;Student&gt; GetEnumerator()
          {
              return StudentList.GetEnumerator();
          }
  
          System.Collections.IEnumerator System.Collections.IEnumerable.GetEnumerator()
          {
              return this.GetEnumerator();
          }
  
  
      public string Name 
              {
                  get { return name ; }
                  set { name = value; }
              } 
  
      public int Age 
              {
                  get { return age ; }
                  set { age = value; }
              } 
      public bool IsAdult 
              {
                  get { return isAdult ; }
                  set { isAdult = value; }
              } 
  
      }
  </code></pre>
  
  <p>Now what I want to do , is to load the result of an oracle query in a new list of student </p>
  
  <pre><code>//...
  try
  
  List &lt; Student &gt; StudentList = new List &lt; Student &gt; (); {
  
      OracleCommand command = new OracleCommand(sqlQuery, connection);
      OracleDataReader oracleDataReader = command.ExecuteReader();
      while (oracleDataReader.Read()) {
  
          age = Convert.Int64(oracleDataReader["age"]);
          name = oracleDataReader["name"].toString();
          isAdult = Convert.boolean(oracleDataReader["isAdult"])
      }
  }
  //...
  </code></pre>
  
  <p>Let's say the query returns 100 students and the student class actually contains 10-15 properties, I only took 3 ( name , age , isAdult ) as an example to explain my issue </p>
  
  <p>Would it be possible to load inside the <code>StudentList</code> every returned row from the query ?</p>