If you want to use LINQ to execute that query, I would put it in a stored procedure and execute that proc via LINQ. Should be very easy to do. There are examples of executing procs in the book.
I hope this helps. Let me know if you need any other info.
Professional SQL Server 2005 XML
Professional WCF Programming: .NET Development with the Windows Communication Foundation