title: Get data from database between specified date and time range using linq-sql
body: <p>I have a table with two separate columns for date and time (SQL Server 2008).</p>
  
  <p>I am trying to get the data between 1 minute before current time and 1 minute after current current time in my asp.net MVC (C#) application.</p>
  
  <p>I have tried to use the where condition as:</p>
  
  <pre><code>ce.Start_Date.Add(ce.Start_Time) &gt;= _currDateTime.AddMinutes(-1) &amp;&amp; 
  ce.Start_Date.Add(ce.Start_Time) &lt;= _currDateTime.AddMinutes(1)
  </code></pre>
  
  <p>But from the above where condition, it throws an error:</p>
  
  <pre><code>The datepart millisecond is not supported by 
    date function dateadd for data type date.
  </code></pre>
  
  <p>How can I correct/rectify this error?</p>