Using Multiple Left joins in LINQ query

[silpa]

Hi,

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.

Silpa

[kenobewan]

Here is a page that may help:
LINQ Query Samples