title: Can i filter Table from LinqToSQL?
body: <p>Good day!</p>
  
  <p>I load some big table via LinqToSql.
  Can i download part of this table? For example, load table where row.dt&lt;=some_date_time?</p>
  
  <p>I do it like this:</p>
  
  <pre><code>Infrastructure.Table = Globals.DataContext.GetTable&lt;SomeTable&gt;();
  </code></pre>
  
  <p>But is still very big - 100 000+ rows.</p>
  
  <p>Can i do like that:</p>
  
  <pre><code>DateTime filterDate=new DateTime(2014,5,1,0,0,0);
  Infrastructure.Table = Globals.DataContext.GetTable&lt;SomeTable&gt;().Where(item=&gt;item.dt&lt;=filterDate);
  </code></pre>
  
  <p>I cannot do that,because i shoud cast it to IQueryable.
  This result table contains only rows that item.dt&lt;=filterDate?</p>
  
  <p><em>i try to get less table as i can</em> </p>
  
  <p>So,how to filter this table via date time? and cast it to System.Linq.Table?</p>
  
  <p>Thank you!</p>