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 SrivastavaPosted Sep 1, 2013, 2:20 PM
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