How to get IQueryable() instead of List() using LinQ?
<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>