Is it possible to use Soundex (or other SQL functions) in LinqToSql?

Question

I'm refactoring some code currently implemented in stored procedures to use LinqToSql (for use in training). Is it possible to use SQL functions in a linqToSql Query?

Answer 1

Here is some helpful information from a MSDN Forum Post. Soundex and LINQ.

Answer 2

I haven't tried it myself yet but the below method originally posted here seems to be the best possible solution.

    [Function(Name="SoundEx", IsComposable = true)]
    public string SoundsLike(string input)
    {
        throw new NotImplementedException();
    }