将SQL语句转换为Linq
我是linq初学者,想请大家帮忙将下面的sql语句用linq表达出来
SELECT * FROM a LEFT JOIN
(
SELECT * FROM b
WHERE LangID = 'ZH-tw'
)
as c ON a.id = c.id

[解决办法]

C# code

Var p= from t  in a inner join bon a.id=b.idwhere b.LangID='ZH-tw'select p
[解决办法]
探讨

我是linq初学者,想请大家帮忙将下面的sql语句用linq表达出来
SELECT * FROM a LEFT JOIN
(
SELECT * FROM b
WHERE LangID = 'ZH-tw'
) 
as c ON a.id = c.id