У linq to sql есть опция с связями?
я пытаюсь переместить следующий запрос в Linq-to-sql, это возможно?
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
Я не видел в любом случае делать с галстуками в linq.