select a.column1,a.column2,(select t.column3 from table2 as t where t.id=a.id) as column3,(select b.column4 from table3 as b where b.id=a.id) as colunm4from table1 as a
這樣的SQL查詢用Linq怎么寫??？
1 回答
滄海一幻覺
TA貢獻1824條經(jīng)驗 獲得超5個贊
var query= from a in db.table1 select new {a.column1,a.column2,
column3= db.table2.FirstOrDefault(f=>f.id==a.id).column3 ,
column4= db.table3.FirstOrDefault(f=>f.id==a.id).column4 ,
};
???????
- 1 回答
- 0 關注
- 341 瀏覽
添加回答
舉報
0/150
提交
取消