title: combine two datetime to one and use it in linq
body: <p>I have a linq query, need combine datetimeA.date+DateitmB.time. How to do that?</p>
  
  <pre><code>var sample = (from e in dataContext.tblA.Include("tblB")
                where (e.Active == true &amp;&amp; DateTime.Parse(e.DateA.ToShortDateString() + " " +e.DateB.ToShortTimeString()) &gt;= DateTime.Now )
                          select new 
                          {
                          ...
                          }).ToList();
  </code></pre>
  
  <p>I tried using</p>
  
  <pre><code>new DateTime(e.DateA.Year, e.DateA.Month,e.DateA.Day,e.DateB.Hour,e.DateB.Minute,e.DateB.Second) &gt;= DateTime.Now
  </code></pre>
  
  <p>but I can't do that in linq </p>