SQL查询到linq语法

SELECT pv.Product_ID, pv.Product, v.Add_ID, v.Product_ID
  FROM Product AS pv 
  JOIN Product_Add AS v
  ON ((pv.Product_ID = v.Add_ID) OR (pv.Product_ID = v.Product_ID))
     where(( pv.Product_ID = v.Product_ID) OR (pv.product_ID = v.Add_ID))

from pv in Product
from v in Product_Add
where ((pv.Product_ID == v.Add_ID) || (pv.Product_ID == v.Product_ID))
     &&(( pv.Product_ID = v.Product_ID) || (pv.product_ID = v.Add_ID))

问题状态

• 最新活动: 2020-05-12 12:43
• 浏览: 27
• 关注: 72 人