日期:2014-05-20  浏览次数:20817 次

将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 b
on a.id=b.id
where 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