How do I translate this mssql query to LINQ syntax? I cant really get it when I have several where clauses:
How do I translate below MSSQL query to LINQ syntax? I can not really get it when I have several where clauses....
SELECT * FROM WeighRows WR
WHERE WR.OrderNumber NOT IN
(
SELECT WRT.OrgOrderNumber FROM WeighRowsTemp WRT WHERE WRT.OrgOrderNumber = WR.OrderNumber
AND WRT.SeqNo = WR.SeqNo
AND WRT.ImportSeqNo = WR.ImportSeqNo
)