یکی از اساتید این کد sql به linq تبدیل کنه

[mustafaehsani]

SELECT dbo.Credit.CName, dbo.Credit.Unit FROM dbo.Credit
INNER JOIN dbo.[H.Kardani] ON dbo.Credit.CID = dbo.[H.Kardani].CreID
WHERE (dbo.[H.Kardani].CreID = @CreID)

[aboulfazl950]

=var sel
from o in Context.Credit join u in Context.Kardani)
on o.CID equals u.CreId where u.CreId=@CreID
select new
}
,o.CName
o.Credit
;()toList.({