title: Linq: Date less that x, but next record date is greater that x
body: <p>I got records in database. Each record has field "Date". 
  For given date=x i need to find records that Date value is less that x, but next record date is greater of x.</p>
  
  <p>Example:</p>
  
  <pre><code>id  date
  --------------
  1   12.03.2013
  2   15.03.2013
  3   18.03.2013
  </code></pre>
  
  <p>now, I got <code>X=16.03.2013</code>, and i need a LINQ that return this record:</p>
  
  <pre><code> 2  15.03.2013
  </code></pre>
  
  <p>BUT! for the <code>X=15.03.2014</code> it should return nothing (because there is record with smaller date, but next record has exactly the same date as X) </p>
  
  <p>How can i do this? </p>