How to get a distinct records with multiple columns using linq? Following code is returning multiple records, which is correct, but I want to get distinct records from the table p ( for p.PId)? How do i do that? listViewModel.EmailRecipients.AddRange( from r join p on r.PId equals p.PId join gp on p.PId equals gp.PId join hp on gp.HPId equals hp.HPId orderby p.LastName, p.FirstName select(new EmailRecipientViewModel { PId = p.PId, FirstName = p.FirstName, LastName = p.LastName, Email = "", }) );