Question

我对条款有多重条件提出疑问。

SELECT * 

 FROM   
       CATALOGITEM  with (nolock) INNER JOIN CATALOG with (nolock) ON
       CATALOGITEM.catalog_id = CATALOG.catalog_id and not(catalog.catalog_id = 21) AND NOT(catalog.catalog_id = 20)

       INNER JOIN PRODUCT with (nolock)  ON   
         CATALOGITEM.s_num = PRODUCT .s_num   
        LEFT OUTER JOIN PRODUCT_DETAIL with (nolock)  ON 
       PRODUCT_DETAIL.s_num = PRODUCT.s_num      
           WHERE
           (  
              CATALOGITEM.publish_code =  upd  OR  
              CATALOG_ITEM.publish_code =  ins  OR  
              PRODUCT.publish_code =  upd  OR  
              PRODUCT.publish_code =  ins   
           )  

       and
       (CATALOG.unit_id = bu.unit_id)

如何在LINQ中撰写。

请提出咨询意见。

Answer 1

认为你没有加入防止母婴传播方案?

无论如何,这应该让你们开始。

var query = (from ci in db.catalogitem
         join c in db.catalog on ci.catalog_id equals c.catalog_id
         join p in db.products on ci.s_num equals p.s_num
         join pd in db.productdetail on p.s_num equals pd.s_num into tempprods
         from prods in tempprods.DefaultIfEmpty()
         where !(c.catalog_id.Contains(21, 20))
         && (ci.publish_code.Contains( upd , ins )) ||
            (p.publish_code.Contains( upd , ins ))
         select ci)

Answer 2

如果你想要保护(NOLOCK)的背心,我就在C#中使用了推广方法,。

友情链接