Convert Sql Query to Linq ?

Question

Sql Query :

 

SELECT
c1.Value1 AS Market, c2.Value2 AS Country, c1.Value3,c3.title,c3.Value4
FROM
Table1 c1
JOIN
Table1 c2 ON c1.Id= c2.Id
JOIN
Table2 c3 on c3.Id= c1.Id
WHERE
c1.Id= 29 AND c2.Id= 33 and c3.title like '%Henan%'

 

Thanks in advance !