How to convert SQL Query to Linq syntax?

You can convert common SQL Queries to Linq syntax using Linq Converter.

try with this Linqer:

 http://www.sqltolinq.com

OR

LinQPad:  http://www.linqpad.net/