LINQ where clause is being ignored

Question

I am have an issue with a linq query. I am joining two tables but the where clauses are being completely ignored.

using (var db = new Context())
{
    var count = (from c in db.PERSON
                 join dt in db.DATA_INPUT_CHANGE_LOG
                      on c.DataInputTypeId equals dt.DataInputTypeId
                 join x in db.DATA_INPUT_CHANGE_LOG 
                      on c.Id equals x.DataItemId
                 where c.PersonId == p1Id &&
                  c.RefPersonId == p2Id && 
                  c.RelationshipId == rId
                 where x.Approved
                 where x.Checked
                 where x.Hidden == false
                 select c).Count();

    return count > 0;
}

In this particular query the x.Approved, x.Checked and x.Hidden == false where clauses are completely ignored.

Can anyone point me in the right direction?

Take a look here: http://stackoverflow.com/questions/679644/multiple-where-clause-in-linq You probably want to specify where once — Michael B, Jun 11 '15 at 12:20
Have you run a profiler against your database to see exactly what sql is generated from that LINQ? — slugster, Jun 11 '15 at 12:29
Why are you using multiple where's instead of just one and AND's? — Gusman, Jun 11 '15 at 12:30

score -1 · Answer 1 · answered Jun 11 '15 at 13:07

Your syntax is incorrect. You should only have one where clause. See below:

            var count = (from c in db.PERSON
                         join dt in db.DATA_INPUT_CHANGE_LOG
                              on c.DataInputTypeId equals dt.DataInputTypeId
                         join x in db.DATA_INPUT_CHANGE_LOG
                              on c.Id equals x.DataItemId
                         where c.PersonId == p1Id &&
                          c.RefPersonId == p2Id &&
                          c.RelationshipId == rId &&
                          x.Approved &&
                          x.Checked &&
                          x.Hidden == false
                         select c).Count();

            return count > 0;

The two options are equivalent. There is nothing *wrong* with multiple `where` clauses. They'll still work just fine. — Servy, Jun 11 '15 at 13:33

LINQ where clause is being ignored

1 Answers1