linq multiple condition on "on" clause

Posted by swapna on Stack Overflow See other posts from Stack Overflow or by swapna
Published on 2010-06-07T09:52:47Z Indexed on 2010/06/07 10:02 UTC
Read the original article Hit count: 297

Filed under:

I have a query which have multiple conditions on on clause

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)

WHERE
(
CATALOGITEM.publish_code = 'upd' OR
CATALOG_ITEM.publish_code = 'ins' OR
PRODUCT.publish_code = 'upd' OR
PRODUCT.publish_code = 'ins'
)

How to write this in linq.

Please advice.

© Stack Overflow or respective owner

Related posts about LINQ