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: 303
LINQ
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