How to translate lambda expressions to the TSQL statement

Question

e.g.

x => x.UserId > 5 &&
     x.Name.StartWith("S") &&
     x.Name.EndWith("D") &&
     x.Name.Contains("x")

to

it.UserId > 5 And it.Name like 'S%' And it.Name like '%D' And it.Name like '%x%'

Answer 1

Rob Connery did it with Subsonic, and Subsonic is open sourced.

Some docs can be fond on Subsonic site and Subsonic code is here