CODE EXAMPLE FOR SQL

linq inner join

var dealercontacts = from contact in DealerContact
                     join dealer in Dealer on contact.DealerId equals dealer.ID
                     select contact;