询问一个Linq表达式的写法
SQL语句是
SELECT ID,Subject,Content,(select Fullname from Person where ID = Owner) as Owner,Time
FROM BBS
WHERE Time >= @StartTime and Time <= @EndTime
我想问一下(select Fullname from Person where ID = Owner) as Owner这部分怎么转换。
我写的是
var query =
from bbs in estwdb.BBS
where 【省略】
select new
{
bbs.ID,
bbs.Subject,
bbs.Content,
Owner = 【这部分不会写】,
bbs.Time
};
请高手指教。
[解决办法]
var query = from bbs in estwdb.BBS
join ps in Person
on bbs.Owner Equls ps.Owner
where 【省略】
select new {
bbs.ID,
bbs.Subject,
bbs.Content,
ps.Owner,
bbs.Time
};
