linq to sql 关联表查询在线等

[Persistence_x]

站点信息表yfdata.site_info;
最近浏览记录表yfdata.site_userb;
我要前4条当前用户最近浏览的站点信息,
浏览记录条是有一个站点同时多次登录的记录,

[Persistence_x]

取出来应该是这4个站点的信息 "5329de1e2548439ca01a1224127feabd" "667ee06e446b4368a102e9f5502e843d" "563e276452b64899b3b4b639a1141ea5" "895816e85caa47c58faf0919e12ef7a6"

[q107770540]

what's your question here?

[蝶恋花雨]

var test=(from p in db.yfdata.site_userb join yfdata.site_info pp on a.bid=b.bid
orderbydescing p.addtime select p).take(4);

大体写法 具体根据你的表来。