Devart Forums

Hi, can anyone tell me how you can make it so that in the non-match between strings it's not case sensitive in a query?
var list = (from p in context.Patient
                         where p.Name.Contains (query) || p.Cognome.Contains (query)
                         orderby p.Name, p.Cognome
                         select p) .ToList ();
In this query the contains is case sensitive and therefore does not return a correct result. how can I do?

Try this way:

One more solution is to change the column data type to citext: https://www.postgresql.org/docs/current/citext.html.