title: How to get IQueryable() instead of List() using LinQ?
body: <p>Data structure:</p>
  
  <pre><code>class Journal
  {    
      public int JournalId {get; set;}
      public DateTime JournalDate {get; set;}
      public string OwnerId {get; set;}
  }
  
  class Event
  {
      public string EventId {get; set;}
      public string EventName {get; set;}
  }
  </code></pre>
  
  <p>Is there any way to get 
  First of all I get that List of values</p>
  
  <pre><code>var events = DBContext.Events.Where(o =&gt; o.EventName.Contains(searchParam)).AsQueryable();
  var values = events.Select(x =&gt; x.EventID).ToList();
  </code></pre>
  
  <p>I only know how to put query results to list in foreach cycle. I created new list put there all values where events in list of values I need</p>
  
  <pre><code>JournalList  = new List&lt;Journal&gt;();
  foreach (string eventId in values)
  {
     var results = DBContext.Journals.Where(j =&gt; j.eventID.Equals   (eventId)).ToList();
     RegJournalList.AddRange(results);
  }
  
  GroupedList = JournalList.Select(t =&gt; new JournalGrouped()
  {
    JournalID = t.JournalID,
    JournalDate = t.JournalDate
  }).Distinct().ToList();
  </code></pre>
  
  <p>Is there a way to have <code>IQueryable()</code> instead of <code>JournalList</code>?</p>