Convert Sql query to Linq

Sep 1 2013 5:04 AM

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)

Select dynamic columns with Linq c#