title: Select a table column from IEnumerable using Linq
body: <p>Am having my table as below , by the usage of Sqlite :</p>
  
  <pre><code>public class Medication
  {
      [PrimaryKey, AutoIncrement]
      public int ID { get; set; }
      public string unique_id { get; set; }
      public string username { get; set; }
      public string insulin_type { get; set; }
      public string units { get; set; }
      public string status { get; set; }
  
      public string alarm_time { get; set; }
      public Medication() { }
  }
  </code></pre>
  
  <p>Now I want to use <code>IEnumerable</code> to get a Column <code>alarm_time</code> List but I don't know how to get it. Below is my code for that:</p>
  
  <pre><code>public IEnumerable&lt;Medication&gt; AllMedicationResults()
  {
      return (from t in _connection.Table&lt;Medication&gt;()
              select t).ToList();
  }
  </code></pre>
  
  <p>How can I include the Column <code>alarm_time</code> in that code above.</p>