Hoe to write join query in linq

Ankita Yadav

10y1.1kLINQ

select D.DealerID,D.LeadTypeId ,D.Email,L.Name from LeadType L,DealerEmailLeadTypeTie D where D.LeadTypeId=L.LeadTypeId And d.DealerID=@DealerID

how to write this query into linq using lambda expression

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

El Mahdi Archane10y ago
Hi,
Please try the following code :
int aDealerID
var Result = DealerEmailLeadTypeTie.Where(D=>D.DealerID==aDealerID).Join(LeadType,
D=>D.LeadTypeId,
L=>L.LeadTypeId,
(D,L)=> select new
{
DealerID=D.DealerID,
LeadTypeId=D.LeadTypeId,
Email=D.Email,
Name=L.Name
});
0
Mansi Gupta10y ago
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
0
Munesh Sharma10y ago
http://www.dotnetperls.com/join
0
Ankita Yadav10y ago
Thanks but can we write this query using lambda Expressions
0
Sujeet Suman10y ago
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.
+1
Raja T10y ago
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
0