What is linq query for SQL and Soudex for SQL Server 2008?

Question

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')

which linq query will match above sql?

Answer 1

from t in table
where t.column.Contains("myword")
select t

In .Net 4.0, you can use the SoundCode function, perhaps like this:

from p in person
where SqlFunctions.SoundCode(p.LastName) == SqlFunctions.SoundCode('Ann')
select p

Answer 2

you can use the difference function

http://msdn.microsoft.com/en-us/library/system.data.objects.sqlclient.sqlfunctions.difference%28VS.100%29.aspx

you can also create your own

https://web.archive.org/web/1/http://blogs.techrepublic%2ecom%2ecom/programming-and-development/?p=656