Was looking to convert a complex SQL query and short on time, so came across this nifty little tool to automate the conversion! It even outputs and autobuilds necessary classes!
At the time of this article supports all versions of Linq in .Net up to 4.0.
References
Linqer, http://www.sqltolinq.com/
{handshake sound} 
Leave a comment