471,120 Members | 1,413 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,120 software developers and data experts.

Using Multiple Left joins in LINQ query


I have an SQL query like this

select distinct t1.prodID from Table1 t1
left join Table2 t2 on t2.prodID = t1.prodID
left join Table3 t3 on t3.serialno = t2.Id and t3.Qty = 0
where t3.Id is null

This query is having 2 left joins.

How to write a LINQ query for this.
When I searched over Internet regarding this Linq query,I have found that the samples are using one join but none for multiple joins.

Please suggest or help me regarding this.

Thanks in advance.

Jun 13 '08 #1
1 9834
4,871 Expert 4TB
Here is a page that may help:
LINQ Query Samples
Jun 13 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

9 posts views Thread by Ed_No_Spam_Please_Weber | last post: by
5 posts views Thread by jim | last post: by
2 posts views Thread by narendra vuradi | last post: by
9 posts views Thread by shapper | last post: by
4 posts views Thread by Jon Skeet [C# MVP] | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.