In sql server, we can issue sql to get data like
select * from table where column like '%myword%' select * from person where Soundex(LastName) = Soundex('Ann')
what's the linq query to match above sql?
you may want to use the difference function
you could also create your own
from t in table where t.column.Contains("myword") select t
In .Net 4.0 you can use the SoundCode function, probably like this:
from p in person where SqlFunctions.SoundCode(p.LastName) == SqlFunctions.SoundCode('Ann') select p