Can I use Soundex (or other SQL functions) in LinqToSql?

Question

I am reorganizing some code that is currently being implemented in stored procedures for using LinqToSql (for use in training). Is it possible to use SQL functions in linqToSql query?

Answer 1

Here is some helpful information from the MSDN Forum post. Soundex and LINQ .

Answer 2

I have not tried this myself yet, but the method originally posted here seems to be the best solution.

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