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?
views:
61answers:
2
A:
you may want to use the difference function
you could also create your own
http://blogs.techrepublic.com.com/programming-and-development/?p=656
John Boker
2009-10-13 17:18:44
Thank you. As the information said: You cannot call this function directly. This function can only appear within a LINQ to Entities query. I use entity framework as DAL. So how to write it in INQ to Entities query? Say q is EntityQuery<person>, query should be like something as q = q.Where(p => p.LastName.Soundex() == someword);? But I can't do it.
KentZhou
2009-10-13 17:40:13
If i were you i'd probably create a stored procedure to do this. I dont know of another way.
John Boker
2009-10-13 18:12:52
A:
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
Gabe
2010-03-19 00:46:19