title: Union order in Linq to Entities
body: <p>I have a problem with EDM model Union select.
  I have the records in db with uniqe Ids. For example id list:
  1, 2, 3, 4, 5, 6, 7, 8, 9</p>
  
  <p>I need to select, for example, record #6 and 2 records before #6 and 2 records past #6.
  In select result it should be 4,5,6,7,8</p>
  
  <p>I made this next way:</p>
  
  <pre><code>public IQueryable&lt;photos&gt; GetNextPrev(Int64 photoid, string userlogin)
      {
          var p1 = (from m in db.photos
                   where m.id &lt; photoid &amp;&amp; m.userlogin == userlogin
                   orderby m.id descending
                   select m).Take(2).Skip(0);
          var p2 = (from m in db.photos
                    where m.id &gt;= photoid &amp;&amp; m.userlogin == userlogin
                    orderby m.id descending
                    select m).Take(3).Skip(0);
          return (p1.Union(p2));
      }
  </code></pre>
  
  <p>But the ordering is not like in the example...</p>
  
  <p>Thanks for the help!</p>