2 u012757593 u012757593 于 2013.11.07 15:28 提问

求大神,帮忙把SQL转成LINQ,小弟第一次涉及LINQ需要参考谢谢了

select * from (
select a.code,a.gid from productonsale a,
productinformation b,
GeneralStandardCategory c
where a.prodid=b.gid
and b.StdCatID =c.gid
and c.code in ('607','609')
and a.ChlID='0DB3B832-3E16-E111-A1F0-4437E63336BD'
union all
select a.code,a.gid from productonsale a,
productinformation b,
GeneralStandardCategory c,
ProductAttribute d,
(select gid,matter from GeneralResource where matter like '%1860%') e
where a.prodid=b.gid
and b.StdCatID =c.gid
and a.prodid=d.prodid
and d.content=e.gid
and c.code in ('603','602')
and a.ChlID='0DB3B832-3E16-E111-A1F0-4437E63336BD'
) date where Gid='5577b910-103a-e311-a37d-00e081d461dd'

Csdn user default icon
上传中...
上传图片
插入图片
准确详细的回答,更有利于被提问者采纳,从而获得C币。复制、灌水、广告等回答会被删除,是时候展现真正的技术了!