There are Q+A's for Entity Framework LIKE's in the Full .net framework:
from c in dc.Organization where SqlMethods.Like(c.Boss, "%Jeremy%")
This doesn't work in EF Core:
The name SqlMethods does not exist in the current context.
So how do you do a LIKE using Entity Framework CORE?
The LIKE function has moved under
EF.Functions in Core:
from c in dc.Organization where EF.Functions.Like(c.Boss, "%Jeremy%")
Like function you can use
from c in dc.Organization where c.Boss.Contains("Jeremy")