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"));
2
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"));
2
solved LINQ ignoring where clause with method syntax [duplicate]