title: C# Linq to SQL Query Not Returning results but generated SQL works fine?
body: <p>I am trying to run the below code with LINQ to SQL. I know the results return back zero. But when I run the correlating SELECT statement that LINQ generates in SQL Server Management Studio and substitute the parameters for the values it returns a result. Any ideas?</p>
  
  <pre><code>var qryRes = (from res in dbHistoryContext.tblResumes
               where res.updateddate &gt;= dtDateFrom.Date &amp;&amp; res.updateddate &lt;= dtDateTo.Date
              select res);
  </code></pre>
  
  <p>It returns the SQL code:</p>
  
  <pre><code>SELECT [t0].[resumehistoryid], [t0].[resumeid], [t0].[monsterid], [t0].[resumetitle], [t0].[updateddate], [t0].[updatedstatus], [t0].[source], [t0].[lastmodified], [t0].[modifiedby], [t0].[datechanged], [t0].[monsterhistoryid], [t0].[changetype]
  FROM [dbo].[tblResume] AS [t0]
  WHERE ([t0].[updateddate] &gt;= @p0) AND ([t0].[updateddate] &lt;= @p1)
  </code></pre>
  
  <p>where @p0 = '4/01/2015 12:00:00 AM'
  and @p1 = '04/30/2015 12:00:00 AM'</p>
  
  <p>But for some reason the returned SELECT statement works when directly copies and pasted and ran against the dbContexts database but the LINQ to SQL doesn't seem to return any results when I do:</p>
  
  <pre><code>var lst = qryRes.ToList();
  </code></pre>
  
  <p>the count is zero. Any ideas? I know my connection is good. I know the datacontext is pointing to the right database - looked several times and refreshed my dbml several times. It only seems to happen when trying to do the date between another date. Which I know can be tricky. Am I missing something here?</p>