1
Answer

Convert Sql query to Linq

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

Answers (1)