What is the syntax for an inner join in LINQ to SQL?

Question

I'm writing a LINQ to SQL statement, and I'm after the standard syntax for a normal inner join with an `ON` clause in C#. How do you represent the following in LINQ to SQL: select DealerContact.* from Dealer inner join DealerContact on Dealer.DealerID = DealerContact.DealerID

Answer 1

Assuming you already have a linq2sql models called Dealer & DealerContacts, the correct syntax would be:

var dealerContacts = from d in Dealer

join dc in DealerContact on d.DealerID equals dc.DealerID

select new {

dc

};

you must use the equals keyword for this to work.