Linq query output does not match with Sql query output

Question

Repository.Calls
    .Count(call => call.OutcomeActionDate.Value >= fourWeeksStartDate && 
                   call.OutcomeActionDate.Value < threeWeeksStartDate && 
                   call.UserId == user.UserId);

Above query gives me output 1 and the sql query:

select * 
from calls 
where userid = 1006 and
      outcomeactiondate >= '2013-08-19' and
      OutcomeActionDate < '2013-08-26'

gives me the output 15.

The output 15 is correct. I am not sure why is the linq query giving me incorrect value ? All the parameter values used in select query are same as passed in the linq query.

Have you used SQL Profiler to look at the SQL been generated by your code and checked it is what you expect? — DaveShaw
– DaveShaw, Commented Sep 17, 2013 at 21:16
What are the values of fourWeeksStartDate, threeWeeksStartDate, user.UserId. Most likely they are different from the ones in the sql query. — Sam Aleksov
– Sam Aleksov, Commented Sep 17, 2013 at 21:17
Date used must be in date format, some times we have time and we use the datetime that creates problems. — Iti Tyagi
– Iti Tyagi, Commented Sep 18, 2013 at 6:22

Sergey Berezovskiy · Accepted Answer · 2013-09-17 21:17:03Z

2

Try to use Date part of filtered dates:

Calls.Count(call => call.OutcomeActionDate.Value >= fourWeeksStartDate.Date &&
                    call.OutcomeActionDate.Value < threeWeeksStartDate.Date &&
                    call.UserId == user.UserId);

answered Sep 17, 2013 at 21:17

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Linq query output does not match with Sql query output

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related