Convert Sql query to Linq

Question

Hi Can somebody help me on this? I want to convert sql to Linq. SELECT * FROM dbo.ContractPOConfiguration cpoc INNER JOIN dbo.PurchaseOrderLevel pol ON cpoc.PurchaseOrderLevelID = pol.PurchaseOrderLevelID LEFT JOIN dbo.POConfigurationDetail pocd ON pocd.ContractPOConfigurationID = cpoc.ContractPOConfigurationID AND pocd.IsDeleted = 0 AND pocd.MDOInstanceStatusID = 8 LEFT JOIN dbo.POConfigurationType poct ON pocd.POConfigurationTypeID = poct.POConfigurationTypeID

Abhineet Srivastava · Answer

I strongly suggest you that first go & take some basic knowledge of LINQ. Your query should be like that- Var result=From cpoc in dbo.ContractPOConfiguration cpoc join pol in dbo.PurchaseOrderLevel on cpoc.PurchaseOrderLevelID equal pol.PurchaseOrderLevelID Select new{ which field you want to show here} Like that... Cheers