Using Like in LINQ
Contains can be used like
Context.table.fieldname.Contains(“Criteria”)
var query = from u in context.users
where (u.full_name.Contains(criteria) || u.email.Contains(criteria))
select u;
Contains can be used like
Context.table.fieldname.Contains(“Criteria”)
var query = from u in context.users
where (u.full_name.Contains(criteria) || u.email.Contains(criteria))
select u;