title: DocumentDB how to LINQ query on _TS?
body: <p>I want to query the update timestamp _ts on documents to get documents that haven't mutated since a certain amount of time.</p>
  
  <p>When I create a select query in the azure portal this works:</p>
  
  <pre><code>SELECT TOP 10 c.id FROM c WHERE c._ts &lt; 6.35909919217878E+17
  </code></pre>
  
  <p>The wierd number is the Ticks created with a datetime object, see below.</p>
  
  <p>But when I try to create it through LINQ it won't do because you don't have _ts but a Timestamp as a DateTime object. When I try to enter a full DateTime object to compare to the Timestamp it crashes saying it doesn't support it. So I try this:</p>
  
  <pre><code>DocRepo.Get(x =&gt; x.Timestamp.Ticks &lt; CloseDate.Ticks);
  </code></pre>
  
  <p>This results to nothing and when I watch the query executed it has this as a select query:</p>
  
  <pre><code>SELECT * FROM root WHERE root[\"_ts\"][\"Ticks\"] &lt; 6.35909943137688E+17
  </code></pre>
  
  <p>Is it possible to query on the _ts timestamp or do i have to have an extra updatedAt field to do it, which seems redundant.</p>