[Solved] LINQ ignoring where clause with method syntax [duplicate]

You need to say

query = query.Where(x => x.STUDENT_LAST_NAME.StartsWith("Lewis"));

instead of just

query.Where(x => x.STUDENT_LAST_NAME.StartsWith("Lewis"));