求一句sql语句.该如何处理

求一句sql语句.

SQL code

select * from t_item a left join(select * from products) b on a.shopid=b.id where a.userid=15 and a.brandid=12

这个sql语句用linq to sql来表达，该怎么表达

[解决办法]
帮顶 今天看了一天linq 硬是写不出来
[解决办法]
var q =
from a in db.t_item 
join b in db.products on a.shopid== b.id equals into bc
from c in bc
where a.userid=15 and a.brandid=12
select a;
[解决办法]
2楼正解
[解决办法]
on a.shopid equals b.id into bc ?
[解决办法]
var q = 
from a in db.t_item 
join b in db.products on a.shopid equals b.id
where a.userid=15 and a.brandid=12 
select a;
[解决办法]
它得语法和SQL差不多。
[解决办法]
.................
[解决办法]
2楼 正解
[解决办法]

探讨

var q =
    from a in db.t_item
    join b in db.products on a.shopid== b.id equals into bc
    from c in bc
    where a.userid=15 and a.brandid=12
    select a;

[解决办法]
2楼对了。
[解决办法]
2楼 正解了，楼主接贴

查看更多 下一篇