Hoe to write join query in linq

Question

select D.DealerIDD.LeadTypeId D.EmailL.Name from LeadType LDealerEmailLeadTypeTie D where D.LeadTypeId=L.LeadTypeId And d.DealerID=@DealerID how to write this query into linq using lambda expression

Sujeet Suman · Answer

Ankit please try below code once: var resultset = from LeadType in db.LeadType join DealerEmailLeadTypeTie in db.DealerEmailLeadTypeTie on DealerEmailLeadTypeTie.LeadTypeId equals LeadType.LeadTypeId and LeadType.LeadTypeId equals DealerEmailLeadTypeTie . select new { LeadType.DealerID LeadType.LeadTypeId LeadType.Email DealerEmailLeadTypeTie.Name }; blue color: table variables green color: data context as per your table pink color: join/where conditions purple color: selected columns If this is helpful for you then please accept my Answer .

El Mahdi Archane · Answer

Hi Please try the following code : int aDealerID var Result = DealerEmailLeadTypeTie.Where(D=>D.DealerID==aDealerID).Join(LeadType D=>D.LeadTypeId L=>L.LeadTypeId (DL)=> select new { DealerID=D.DealerID LeadTypeId=D.LeadTypeId Email=D.Email Name=L.Name });

Mansi Gupta · Answer

Hi Please try the below code var result = dealerEmailLeadTypeTie .Where(d=>d.DealerID == 1) . Join(leadType D => D.LeadTypeId L => L.LeadTypeId (D L) => new { DealerID = D.DealerID LeadTypeId =D.LeadTypeId Email =D.Email Name =L.Name } ) ; You can go through the below link for more information http://stackoverflow.com/questions/2767709/c-sharp-joins-where-with-linq-and-lambda

Munesh Sharma · Answer

http://www.dotnetperls.com/join

Ankita Yadav · Answer

Thanks but can we write this query using lambda Expressions

Raja T · Answer

Hello Ankita Please refer below links http://www.dotnet-tricks.com/Tutorial/linq/UXPF181012-SQL-Joins-with-C http://www.dotnetperls.com/join http://stackoverflow.com/questions/37324/what-is-the-syntax-for-an-inner-join-in-linq-to-sql