title: How to select +1 record from MSSQL using EF with single query?
body: <p>In short:</p>
  
  <p>I have records that have <code>CreationTime</code> column in database. I want to select records from last 2 days PLUS one record that follows (sort by creation date desc) that can be any time old.</p>
  
  <p>So from records (knowing that today date is 11th March) I want to select all records that are at max 2 days old + 1:</p>
  
  <pre><code>1. 2019-03-11
  2. 2019-03-11
  3. 2019-03-10
  4. 2019-03-08
  5. 2019-03-07
  6. 2019-03-16
  </code></pre>
  
  <p>So result should contain records 1,2,3,4. (4. even though it is 3 days old, it is that "+1" record I need).</p>
  
  <p>I'm using MSSQL and .NET 4.6.1 Entity Framework.</p>