title: How do I use SQL's GETDATE() and DATEADD() in a Linq to SQL expression?
body: <p>If I have a <code>Linq</code> to <code>SQL</code> expression like this:</p>
  
  <pre><code>  from subscription in dbContext.Subscriptions
   where subscription.Expires &gt; DateTime.Now
  select subscription
  </code></pre>
  
  <p>I want this to to use the SQL Servers <code>GETDATE()</code> function instead of the time of the machine running the <code>C#</code> program.</p>
  
  <p>The next question would be how to translate this:</p>
  
  <pre><code>DateTime.Now.AddDays(2)
  </code></pre>
  
  <p>to this:</p>
  
  <pre><code>DATEADD(dd, 2, GETDATE())
  </code></pre>