How to do SQL Like % in Linq?
.Where(oh => oh.Hierarchy.Contains("/12/"))
You can also use .StartsWith() or .EndsWith().
Use this:
from c in dc.Organization
where SqlMethods.Like(c.Hierarchy, "%/12/%")
select *;
How to do SQL Like % in Linq?
.Where(oh => oh.Hierarchy.Contains("/12/"))
You can also use .StartsWith() or .EndsWith().
Use this:
from c in dc.Organization
where SqlMethods.Like(c.Hierarchy, "%/12/%")
select *;