Hi I need to retrieve all students by like clause on multiple fields but distinctivly. For e.g. select distinct(StudentId),*,State.StateName from Student where Student.Name like '%john%' or Student.FatherName like '%john%' left join State on Student.StateId = State.StateId

Please tell me how to do this in self service??

I'm not sure I follow you.

Distincit is applied to the entire row, Distinct can\t be applied to a field, that's a database rule. If this is what you are asking for.

You can have more than one predicate added to a PredicateExpression, and in your case you will need to use AddWithOr() to add the second predicate.

Yes I wan't to get distinct rows i.e. distinct entities in entitycollection

Entities are always fetched using distinct, i.e. you can't get duplicate entities when fetching them.