You can convert common SQL Queries to Linq syntax using Linq Converter.
try with this Linqer:
http://www.sqltolinq.comORLinQPad: http://www.linqpad.net/