在Linq Query中需要帮助 [英] Need help in Linq Query

问题描述

大家好，



我是linq的新手。我有一个sql，我想转换成linq。任何帮助将不胜感激。

Hi all,

I am new to linq. I've an sql which i want to convert into linq. Any help would be appreciated.

SELECT   MESSEGEID,
         FILENAME,
         DATETIME,
         SENDER,
         FILE_SIZE,
         IO_CREATED_DATE,
         IO_MODIFIED_DATE,
         NUM_ROWS,
         IS_EXCEPTION,
         STATUS,
         SENDING_STATE,
         IS_TRANSFERED,
         ACK_FILENAME,
         MESSAGE_TYPE
  FROM   PACCS.PACCS_MESSAGES M
 WHERE   M.MESSEGEID IN
               (SELECT   INS.MESSAGEID
                  FROM   PACCS.PACCS_INSTRUCTIONS INS
                 WHERE   INS.MESSAGEID IS NOT NULL
                         AND INS.APPLIED_TO = :UNIT_PKEY
                UNION ALL
                SELECT   PC.MESSAGEID
                  FROM   PACCS.PACCS_CONTAINERS PC
                 WHERE   PC.PKKEY = :UNIT_PKEY
                UNION ALL
                SELECT   INS.MODIFIER_MESSAGE_ID
                  FROM   PACCS.PACCS_INSTRUCTIONS INS
                 WHERE   INS.MODIFIER_MESSAGE_ID IS NOT NULL
                         AND INS.APPLIED_TO = :UNIT_PKEY
                UNION ALL
                SELECT   MESSAGE_ID
                  FROM   PACCS.PACCS_PCCSS_SEAL
                 WHERE   UNIT_KEY = :UNIT_PKEY)

提前致谢，

Ovais

Thanks in advance,
Ovais

推荐答案

请浏览 LINQ初学者教程 [ ^ 并尝试这样做。

如果你不做任何事，没有人会这样帮助总的来说。



如果您遇到任何困难，请回到代码项目，并提供确切的查询。

Please go through the LINQ beginner tutorials[^] and try to do it.
Nobody will help this way, if you don't do anything at all.

If you face any difficulty, then come back to Code Project with an exact query.

这篇关于在Linq Query中需要帮助的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！