sql statement to Expression tree

Question

I'm wondering how one would translate a sql string to an expression tree. Currently, in Linq to SQL, the expression tree is translated to a sql statement. How does on go the other way? How would you translate

select * from books where bookname like '%The%' and year > 2008 

into an expression tree in c#?

Answer 1

http://weblogs.asp.net/rajbk/archive/2007/09/18/dynamic-string-based-queries-in-linq.aspx

update

The Entity framework has the Entity SQL language. Not sure if that is what you want though.

http://msdn.microsoft.com/en-us/library/bb738521.aspx

Answer 2

See http://stackoverflow.com/questions/296972/sql-to-linq-tool