title: how to combine two columns Date and Time and compare it with given DateTime using linq
body: <p>I have following columns in database table - Records:</p>
  
  <pre><code>Info - varchar(50)
  Date - DateTime
  Time - varchar(20) , format like hh:mm
  </code></pre>
  
  <p>Now I have a function</p>
  
  <pre><code> public GetRecords(DateTime pDateTime)
      {
      // this function should get all the records from above table whose DateTime is more than pDateTime
      }
  </code></pre>
  
  <p>How can I do using Linq?
  I know how to write a linq query but how can I combine these columns for each row of table and compare with pDateTime.</p>