0
Reply

How do I translate this mssql query to LINQ syntax? I cant really get it when I have several where clauses:

Fredrik Nilsson

Fredrik Nilsson

Aug 10 2012 11:22 AM
1.1k
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
 )