views:

26

answers:

0
var result = (
             from contact in db.Contacts
             where contact.ContactID == id
             join referContactID in db.ContactRefferedBies on contact.ContactID equals referContactID.ContactID
             join referContactName in db.Contacts on contact.ContactID equals referContactID.ContactID
             orderby contact.ContactID descending
             select new ContactReferredByView
             {
                 ContactReferredByID = referContactID.ContactReferredByID,
                 ContactReferredByName = referContactName.FirstName + " " + referContactName.LastName
             }).Single();

Problem is in this line:

join referContactName in db.Contacts on contact.ContactID equals referContactID.ContactID

where referContactID.ContactID is called from the above join line. How to nest these two joins?

Thanks in advance!
Ile