title: Linq select time with date + 1
body: <p>In my SQL 2008 R2, I have this table:</p>
  
  <p><img src="https://i.stack.imgur.com/0rqqc.jpg" alt="enter image description here"></p>
  
  <p>I have create the LINQ syntax to select all hours that greater than computer hour:</p>
  
  <pre><code> public IList&lt;LS_CLIENTHORRAIRE&gt; Get_All_Obj(string CLIENT_ID)
          {
              try
              {
                  IList&lt;LS_CLIENTHORRAIRE&gt; LesListe;
                  using (Soft8Exp_ClientEntities oEntite_T = new Soft8Exp_ClientEntities())
                  {
                      int The_Hour = DateTime.Now.Hour;
                      var query = from o in oEntite_T.LS_CLIENTHORRAIRE where o.CLIENT_ID == CLIENT_ID &amp;&amp; o.HORRAIRE &gt; new TimeSpan(The_Hour, 00/*minutes*/, 00/*seconds*/) select o;
                      LesListe = query.ToList();
                  }
                  return LesListe;
              }
              catch (Exception excThrown)
              {
                  throw new Exception("Err_02", excThrown);
              }
          }
  </code></pre>
  
  <p>and it is work fine:</p>
  
  <ul>
  <li>when the hour computer is <code>08:00</code> then it return <code>12:00</code> and <code>19:00</code>,</li>
  <li>when the hour computer is <code>13:00</code> then it return <code>19:00</code>.</li>
  </ul>
  
  <p>But now I want to change the program that look at the date also:</p>
  
  <ul>
  <li>when the hour computer is <code>08:00</code> then it return <code>12:00</code> and <code>19:00</code> and <code>05:00</code>.</li>
  <li>when the hour computer is <code>13:00</code> then it return <code>19:00</code> and <code>05:00</code>.</li>
  <li>when the hour computer is <code>20:00</code> then it return <code>05:00</code>.</li>
  </ul>
  
  <p>Any idea ?          </p>
  
  <p>i have tried like this:</p>
  
  <pre><code> DateTime The_Date = DateTime.Now.Date;
                      var query = from o in oEntite_T.LS_CLIENTHORRAIRE where o.CLIENT_ID == CLIENT_ID &amp;&amp; The_Date.Add(o.HORRAIRE) &gt; DateTime.Now select o;
                      LesListe = query.ToList(
  </code></pre>
  
  <p>);</p>
  
  <p>but unfortunately it not work</p>