title: Entity framework, get surrounding items of the selected item
body: <p>I want to get an item from db, and items that come before and after it.</p>
  
  <pre><code>var data= repo .OrderBy(a =&gt; a.Date)
                 .Select((item, index) =&gt; new { item, index })
                 .Where(itemAndIndex=&gt;itemAndIndex.item.Id == someId)
  </code></pre>
  
  <p>this is what I got so far.</p>
  
  <p>To clarify,</p>
  
  <p>lets say this is my Table</p>
  
  <pre><code>Id     Name        Date
  1      SomeText1   01.01.2017
  2      SomeText2   03.01.2017
  3      SomeText3   02.01.2017
  4      SomeText4   04.01.2017
  5      SomeText5   05.01.2017
  </code></pre>
  
  <p>I want to do a select query for <code>Id==3</code>, then sort the result by the Date field, and get a list of items</p>
  
  <pre><code>Id     Name        Date
  1      SomeText1   01.01.2017
  3      SomeText3   02.01.2017
  2      SomeText2   03.01.2017
  </code></pre>
  
  <p>like this.</p>
  
  <p>Thank you.</p>