SELECT DISTINCT road.Item_No,  item.Name , qty.MPER , qty.QTY , road.RevisedNotification_Id 

FROM  rms_category_roadmaintenance road, RM_ITEM item, rms_rn_qty qty

WHERE qty.RevisedNotification_Id = road.RevisedNotification_Id
                AND qty.M_No = road.Mno 
                AND item.TYear = road.Tender_Year
                AND item.INo = road.Item_No 
                AND road.Contract_Id = 5
                AND road.Tender_Year = 2014
               AND road.Certificate_Id = 74
               AND road.Delete_Flag = ‘N’ ORDER BY road.Item_No

HI,

Download LINQ pad from http://www.linqpad.net/ . This would do translation from SQL to LINQ or LAMBDA.

Hope helps.