select-求sql轉化為link的代碼

求sql轉化為link的代碼

select top 3 from [dbo.Users] where id in (select id from [dbo.Topics] where userid = 1) order by lastactivetime

最佳回答：

var query = db.Topics.Where(x => x.userid == 1).SelectMany(x => db.Users.Where(y => y.id == x.userid)).OrderBy(x => x.lastactivetime).Take(3);