Czy linq do sql ma opcję z wiązaniami?

Próbuję przenieść następujące zapytanie do Linq-to-sql, czy to możliwe?

select * from (
Select top (@Percent) percent with ties *
from(
    Select distinct
      LoanNumber as LoanNo
    From CHE 
    Left Join RecordingInfo as Rec
    On CHE.LoanNumber = Rec.LoanNo
    Where Channel = 'LINX'
        and CHE.Doc in ('MTG','MOD')
        and Rec.LoanNo is null
        and LoanNumber >= '@LoanNo'
) A
order by LoanNo @Order
) B
order by LoanNo

I tak nie widziałem więzi w linq.

questionAnswers(1)

yourAnswerToTheQuestion