like operator in linq

Question

i need to use the like operator in a linq query

for this:

timb = time.Timbratures.Include("Anagrafica_Dipendente")
                .Where(p => p.Anagrafica_Dipendente.Cognome + " " + p.Anagrafica_Dipendente.Nome like "%ci%");

How can i do?

Answer 1

timb = time.Timbratures.Include("Anagrafica_Dipendente")
           .Where(p => (p.Anagrafica_Dipendente.Cognome + " "
                       + p.Anagrafica_Dipendente.Nome).Contains("ci"));

Answer 2

You can use Contains() for this like so:

var query = (from p in products
            where p.Description.Contains("ci")
            select p);