After working so long on I SQL ,you always need little trick to write you Linq Quires.Here is few tools which might help to generate your linq quries.

SQL to LINQ converter
http://www.sqltolinq.com/

Code Generation in LINQ to SQL
http://msdn.microsoft.com/en-us/library/bb399400.aspx

LINQPad : Code generation for Linq
http://www.linqpad.net/

Converting SQL to LINQ
http://blogs.msdn.com/b/vbteam/archive/tags/converting+sql+to+linq/default.aspx

101 LINQ Samples
http://msdn.microsoft.com/en-us/vcsharp/aa336746

Thanks,

Suresh Behera