title: mysql table into List
body: <p>i use <strong>c#</strong>, <strong>winform</strong> and <strong>mysql</strong> database.<br>
  And i have a table <strong>t_class</strong> in like below  </p>
  
  <pre><code>id        class       group      name        surname
  1         10          1          joe         philips
  2         10          2          maya        edwards
  3         10          4          michael     collins
  4         11          3          sasha       ivanko
  5         10          2          araz        kurio
  etc...
  </code></pre>
  
  <p>and i have a class <strong>MyClass</strong> like this  </p>
  
  <pre><code>class MyClass
  {
      int class;
      int group;
      string name;
      string surname;
  }
  </code></pre>
  
  <p>there is a List  </p>
  
  <pre><code>List&lt;MyClass&gt;  myclass = new List&lt;MyClass&gt;();
  </code></pre>
  
  <p>Can you tell me please,<br>
  how can i load data from t_table into this list.</p>
  
  <p>i wolud like to use LINQ there.
  and not looping in datatable rows for this.</p>